Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar settings in a UserForm
Hi, I have a userform with a vertical scrollbar which works fine, but the scrollbar is slid at the bottom when it shows up for the first time. The users woud have to slide it up to get at the beginning of the form. I tried several settings in VBE under project properties for the form, to have the vertical scrollbar at the top when the form is displayed but without success. Can anyone suggest any solutions ? Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar settings in a UserForm
Look at your tab order. The control with tab order zero should be at the
top of the form. -- Regards, Tom Ogilvy mohsinb wrote in message ... Hi, I have a userform with a vertical scrollbar which works fine, but the scrollbar is slid at the bottom when it shows up for the first time. The users woud have to slide it up to get at the beginning of the form. I tried several settings in VBE under project properties for the form, to have the vertical scrollbar at the top when the form is displayed but without success. Can anyone suggest any solutions ? Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar settings in a UserForm
Hello Tom, The tab order for the controls was correct - 0 thru 9 - top to bottom. I had to change Tabstop to false(was true) for taborder 9. The rest of them were false. Now it works great. Thanks for your help in putting me on the right track. Mohsinb. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrollbar Help | Charts and Charting in Excel | |||
Scrollbar help | Excel Discussion (Misc queries) | |||
Possible to Customize Scrollbar? | Excel Discussion (Misc queries) | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
UserForm remembering Settings | Excel Programming |