Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling of UserForm1
Hi there,
i have one problem, i cannot understand using of scrollbar in vb in excel. I have one userform which is bigger then my screen and i need to put in this form scrollbar and use it for moving my userform to see all things on it. Can anyone help me? Thanx a lot. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling of UserForm1
Try putting code like this in your Initialize event.
Private Sub UserForm_Initialize() Dim lh As Long Me.ScrollBars = fmScrollBarsVertical lh = Me.Height Me.ScrollHeight = lh Me.Height = Me.Height / 2 End Sub Then play with it to get what you want. -- Regards, Tom Ogilvy "frankosun" wrote in message ... Hi there, i have one problem, i cannot understand using of scrollbar in vb in excel. I have one userform which is bigger then my screen and i need to put in this form scrollbar and use it for moving my userform to see all things on it. Can anyone help me? Thanx a lot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
userform1.activecontrol.name | Excel Programming | |||
Userform1 Border | Excel Programming | |||
Userform1 Border | Excel Programming |