PDA

View Full Version : Solved: UserForm scroll bar



ironj32
02-12-2007, 10:28 AM
I have a vertical scroll bar on a userform that will not work for me. it is visible but it does not do anything. any thoughts?

CBrine
02-12-2007, 11:21 AM
ironj32,
Adding a scroll bar to a form, doesn't actually make it do anything. You will need to add code to the scroll bar events and tell if what should happen when it used.

What are you trying to do with it? You may not need it at all depending on the use you want for it.

Cal

ironj32
02-12-2007, 11:25 AM
thanks for your response.
my form is quite a bit taller than the screen...users need to be able to scroll up and down in order to complete the questionaire.

CBrine
02-12-2007, 12:46 PM
ironj32,
Take a look at the properties for your userform. You will see one labeled scrollbars. Just set the options there for a vertical scroll bar, and you should be good to go. Just delete the scroll bar control you added.

HTH
Cal

ironj32
02-12-2007, 01:25 PM
got it...just had to set the scroll height.
Thanks again.