Scroll Bars in Excel Form

MI man

Registered User.
Local time
Today, 11:17
Joined
Nov 23, 2008
Messages
59
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom