View Full Version : Scroll Bars in Excel Form


MI man
04-25-2010, 10:39 PM
This may sound like a silly question...but still, I have this one..:confused:
I am designing a form in Excel, which consists of all checkboxes. A total of 60 checkboxes is what I need to induce into that form. After putting some checkboxes, then form reaches the end of the monitor, I need the form to scroll, just like the windows screen scrolls down. I have tried to put scroll bars through the form properties (that would be displayed to the left of the window), but somehow it's not working out. Could anyone help me out regarding this..??

Please note that this same method works well for the Forms in Access, but not in Excel.

chergh
04-26-2010, 12:07 AM
Look at the forms properties and in particular the scrollbars property and set it to 1, 2 or 3 depending on your requirements and then put in values for scrollwidth for horizontal scrolling and scrollheight for vertical scrolling