Form scrolling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel data input form designed that fits my screen and looks fine.
But if it is a smaller size screen, it would not show scroll bars, so it is
impossible to complete the whole form. Is there anything standard that can be
done to have the bars automatically appear if the form size is larger then a
screen size?

Thank you, Zoya
 
not sure of this helps but there is a setting tools>options>view tab there is
a check box to show the scroll bars. you might want to make sure they are
checked. Also check the protection you have on the sheet and workbook to see
if there is a setting there that needs changing
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Thank you John,

Unfortunately, this is not what I need. I don't have problems with the view
of this form. It becomes a pain, if another user has a smaller screen and
needs to scroll through. The form will not display the scrollbars on the
sides of the screen.

I am wondering if there is a standard property of the form or a visual basic
code that I can add to it to make it "listen" to the size of the window it is
opening in and adjust or display the scroll bars.

Zoya
 
Zoya,
The second example, I posted at the following link, shows how to adjust the
userform size based on the screen resolution... http://tinyurl.com/2jhkft
There is usually a strong correlation between screen size and screen resolution.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Zoya" <[email protected]>
wrote in message
I have an Excel data input form designed that fits my screen and looks fine.
But if it is a smaller size screen, it would not show scroll bars, so it is
impossible to complete the whole form. Is there anything standard that can be
done to have the bars automatically appear if the form size is larger then a
screen size?

Thank you, Zoya
 
Hi,

Higher the screen resolution smaller the image. You can display a message
to caution the user before using the form. For example, This form is best
viewed in 1028 by 1024 pixels screen resolution.

Challa Prabhu
 
Back
Top