Dag,
Hoe kan ik een hoeveelheid checkboxen plaatsen in een Frame met scrollBar?
EDIT:
Gevonden.
1) Don't create any scroll bars on the frame
2) Right click on the frame and click on properties.
3) Under the "KeeScrollBarsVisible", select "2 - fmScrollBarsVertical"
4) Reduce the size of the frame as per your requirement (as shown in your picture)
5) In the Userform Initialize event type this code...
Hoe kan ik een hoeveelheid checkboxen plaatsen in een Frame met scrollBar?
EDIT:
Gevonden.
1) Don't create any scroll bars on the frame
2) Right click on the frame and click on properties.
3) Under the "KeeScrollBarsVisible", select "2 - fmScrollBarsVertical"
4) Reduce the size of the frame as per your requirement (as shown in your picture)
5) In the Userform Initialize event type this code...
Code:
Private Sub UserForm_Initialize()
'Replace Frame1 with the name of your frame
With Me.Frame1
.ScrollBars = fmScrollBarsVertical
'Change 8.5 to suit your needs
.ScrollHeight = .InsideHeight * 8.5
.ScrollWidth = .InsideWidth * 9
End With
End Sub
Laatst bewerkt: