help on scrollbars

[a5]

I am creating a userform by using Visual basics for applications in Excell but my form is too big and I can not view the whole form on the screen so I need to put verticle
scrollbar on it but I dont know how. I do not have enough knowledge about VBA.
Can anyone help as soon as possible. It will be greatly appeciated.
Thanks
Riffat

 

[JeremyNYC]

I haven't designe forms in Excel, but in Access it's not a VBA thing it's a property of the form. Is there a properties screen for the form in Excel? If so, check for a scroll bars property.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[a5]

my form is in the MS Excel but I created this form by
using VBA code. so I need a VBA code to actualy put a scrollbar on the form. are you saying there is no such VBA code to put the scrollbar on the form?
Thanks
Riffat