View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default Resizing user form in excell

click on the userform in the vba editor, then view properties. change
the "Scrollbars" properties as desired.

HTH

Die_Another_Day
wrote:
I have created a form. The form is quite large - 60 fields to fill in
(The customer wanted it that way). The form is larger than the screen
were the resolution is low on the monitor. I can have the customer
adjust the resolution and then the whole form will show up on the
screen.
I was wondering if a scroll bar can be added so the customer can move
to the lower half of the form. How do I add it in?

I tried changing the form properties but that would not allow the form
to be moved or resized.

Any ideas would be greatly appreciated.

Thank you,