Look at the properties window  in the development environment. There are
scroll bars there.

I don't think you can maximise a form. So you'll need to find the window
resolution and resize  the form. The size of the underlying sheet can be
retrieved (don't remember how, but a Google search will find it).

I think I found how to get the scrren resolution. Do you know what is
the vba code to have the form  resized?

I think the form  has width and height properties that you set, plus left and
top properties to position it - like all the other controls. All the
information is available through the help and/or Google searches.

Thanks, I've found some code on google and tried it out. Works some
what. It does enlarge based  on the resolution  but it doesn't lock
in to the display like when you maximize a window  but it works for
me.

Private Sub UserForm_Initialize()

'Set the window size to maximum
Application.WindowState = xlMaximized
frmVA.Width = Application.Width
frmVA.Height = Application.Height