Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
pdffile = ThisWorkbook.Path & "\PDFfiles" & "\" & TextBox1.value
WB_01.Navigate (pdffile)
Private Sub CommandButton1_Click()
'pdffile = ThisWorkbook.Path & "\PDFfiles" & "\" & TextBox1.Value
pdffile = ThisWorkbook.Path & "D:\Project ROBBIE\Test\Factuur 1245 29-3-2017.pdf"
WB_01.Navigate (pdffile)
End Sub
Suc6pdffile = ThisWorkbook.Path & "D:\Project ROBBIE\Test\Factuur 1245 29-3-2017.pdf"
Private Sub CommandButton1_Click()
Dim Litem As Long, LbRows As Long, LbCols As Long
Dim bu As Boolean
Dim Lbloop As Long, Lbcopy As Long
LbRows = ListBox2.ListCount - 1
LbCols = ListBox2.ColumnCount - 1
For Litem = 0 To LbRows
If ListBox2.Selected(Litem) = True Then
bu = True
Exit For
End If
Next
If bu = True Then
With Sheets("SelectedData").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
For Litem = 0 To LbRows
If ListBox2.Selected(Litem) = True Then 'Row selected
'Increment variable for row transfer range
Lbcopy = Lbcopy + 1
For Lbloop = 0 To LbCols
'Transfer selected row to relevant row of transfer range
.Cells(Lbcopy, Lbloop + 1) = ListBox2.List(Litem, Lbloop)
Next Lbloop
End If
Next
For m = 0 To LbCols
With Sheets("SelectedData").Cells(Rows.Count, 1).End(xlUp).Offset(0, m).Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 23
End With
Next
End With
Else
MsgBox "Nothing chosen", vbCritical
End If
MsgBox "The Selected Data Are Copied.", vbInformation
Sheets("SelectedData").Select
End Sub
Private Sub CommandButton1_Click()
Dim Litem As Long, LbRows As Long, LbCols As Long 'variabelen declareren
Dim bu As Boolean 'variabelen declareren
Dim Lbloop As Long, Lbcopy As Long 'variabelen declareren
LbRows = ListBox2.ListCount - 1 'reset
LbCols = ListBox2.ColumnCount - 1 'reset (lbRows en LbCols zijn gegeven namen vrij te kiezen)
For Litem = 0 To LbRows 'van 0 tot het aantal rijen (Litem is een gegeven naam,vrij te kiezen)
If ListBox2.Selected(Litem) = True Then 'als je iets in de listbox hebt gekozen
bu = True 'de variable boolean bu is waar (bu is een gegeven naam,vrij te kiezen)
Exit For 'verlaat de For loop
End If
Next
If bu = True Then
With Sheets("SelectedData").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) 'ga naar de laatst gebruikte rij in kolom A +1
For Litem = 0 To LbRows
If ListBox2.Selected(Litem) = True Then 'Row selected
'Increment variable for row transfer range
Lbcopy = Lbcopy + 1
For Lbloop = 0 To LbCols
'Transfer selected row to relevant row of transfer range
.Cells(Lbcopy, Lbloop + 1) = ListBox2.List(Litem, Lbloop)
Next Lbloop
End If
Next
For m = 0 To LbCols
With Sheets("SelectedData").Cells(Rows.Count, 1).End(xlUp).Offset(0, m).Borders(xlEdgeBottom) 'onderrand van de cellen van alle gebruikte kolommen in de laatst gebruikte rij
.LineStyle = xlContinuous 'doorlopende rand
.Weight = xlMedium ' medium dikte van de rand
.ColorIndex = 23 'kleur van de rand (23 is een bepaald kleur blauw)
End With
Next
End With
Else
MsgBox "Nothing chosen", vbCritical 'popup als je niets hebt gekozen
End If
MsgBox "The Selected Data Are Copied.", vbInformation 'popup als alles succesvol is verlopen
Sheets("SelectedData").Select 'selecteer het blad (is overbodig)
End Sub
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.