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"
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