How to Create an Excel UserForm

7 Responses to “How to Create an Excel UserForm”

1. contextures on: 9 March 2010 at 3:33 pm

   @fraserdes Set the ScrollHeight property to the full height of the user form, when sized to show everything. For example, you might have to set it to 300 to see all the controls, if there were no scroll bar. Then, you can reduce the height of the user form, and the scroll bar will show everything in the ScrollHeight range.
2. fraserdes on: 9 March 2010 at 3:43 pm

   Hi I have created a UserForm similar to yours, but alot longer. The problem I have is that since my form is longer I need a scroll bar, so I added one it through the properties area in the design view but for some reason the scroll button wont work! could you please help me
3. fraserdes on: 9 March 2010 at 4:02 pm

   Hi I have created a UserForm similar to yours, but alot longer. The problem I have is that since my form is longer I need a scroll bar, so I added one it through the properties area in the design view but for some reason the scroll button wont work! could you please help me
4. contextures on: 9 March 2010 at 4:20 pm

   @rimalnigam Thanks! I’m glad you liked the video.
5. rimalnigam on: 9 March 2010 at 4:27 pm

   Your voice and the lesson both are great.
6. contextures on: 9 March 2010 at 4:30 pm

   jigmandude, you’re welcome, and thanks for letting me know that the video helped you.
7. jigmandude on: 9 March 2010 at 5:23 pm

   thank you for poasting this! It helped me create my first user form