Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Scroll Bar work on a form
Hi all,
After set Scrollbars and KeepScrollbarVisible on my form, there are scroll arrow in two end of the bar, but no scroll handler in the middle of the bar. Actually, there is a textbox whose lenght is already over the form length. Clara -- thank you so much for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Scroll Bar work on a form
I assume you want the user to be able to scroll the userform vertically:
In design mode in the VBE, the userform should be large enough hold all the controls. Use code like this in the Userform Initialize event: Private Sub UserForm_Initialize() UserForm1.ScrollBars = fmScrollBarsVertical UserForm1.KeepScrollBarsVisible = fmScrollBarsNone UserForm1.Height = UserForm1.Height / 2 UserForm1.ScrollHeight = 2 * UserForm1.Height ' UserForm1.ScrollWidth = 2 * UserForm1.Width End Sub -- Regards, Tom Ogilvy "clara" wrote: Hi all, After set Scrollbars and KeepScrollbarVisible on my form, there are scroll arrow in two end of the bar, but no scroll handler in the middle of the bar. Actually, there is a textbox whose lenght is already over the form length. Clara -- thank you so much for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Scroll Bar work on a form
Hi Tom,
Thank you very much! It works, but why cann't I do it in properties window of a form. Clara thank you so much for your help "Tom Ogilvy" wrote: I assume you want the user to be able to scroll the userform vertically: In design mode in the VBE, the userform should be large enough hold all the controls. Use code like this in the Userform Initialize event: Private Sub UserForm_Initialize() UserForm1.ScrollBars = fmScrollBarsVertical UserForm1.KeepScrollBarsVisible = fmScrollBarsNone UserForm1.Height = UserForm1.Height / 2 UserForm1.ScrollHeight = 2 * UserForm1.Height ' UserForm1.ScrollWidth = 2 * UserForm1.Width End Sub -- Regards, Tom Ogilvy "clara" wrote: Hi all, After set Scrollbars and KeepScrollbarVisible on my form, there are scroll arrow in two end of the bar, but no scroll handler in the middle of the bar. Actually, there is a textbox whose lenght is already over the form length. Clara -- thank you so much for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make mouse scroll wheel work in excel | Excel Worksheet Functions | |||
How do I make mouse scroll wheel work in excel | Setting up and Configuration of Excel | |||
How do I make the scroll wheel not work on a worksheet? | Excel Worksheet Functions | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
MAKE WHEEL MOUSE WORK ON USER FORM FRAME WITH SCROLL BAR HELP!!!!! | Excel Programming |