Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar
Hello,
First off, I would like to say that I am very new to excel, so I would like to apologize in advance. I am trying to create a userform for data input. The problem is that I want to avoid using tabs to seperate all the information. I would like to add a scrollbar to the userform due to the fact that it is too long. I am having a very hard time performing this task. If possible, could someone tell me if it is possible to add a scrollbar to the userform. If it is possible, could you please provided detailed steps as to how I will add a scrollbar to my userform. Thank You. Best Regards, -AP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar
In the initialize event of the Userform:
Private Sub UserForm_Initialize() UserForm1.ScrollBars = fmScrollBarsVertical UserForm1.ScrollHeight = UserForm1.Height UserForm1.Height = UserForm1.Height / 2 End Sub assumes the entire userform is visible in the VBE (the Userform height includes all the controls) -- Regards, Tom Ogilvy wrote in message oups.com... Hello, First off, I would like to say that I am very new to excel, so I would like to apologize in advance. I am trying to create a userform for data input. The problem is that I want to avoid using tabs to seperate all the information. I would like to add a scrollbar to the userform due to the fact that it is too long. I am having a very hard time performing this task. If possible, could someone tell me if it is possible to add a scrollbar to the userform. If it is possible, could you please provided detailed steps as to how I will add a scrollbar to my userform. Thank You. Best Regards, -AP |
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) | |||
Scrollbar | Excel Programming | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
Scrollbar | Excel Programming |