As a point of information, it doesn't fill the entire screen on my Vista
system (assuming that makes a difference)... it fills maybe 95% of it.

Rick


"Takashi Yamauchi" wrote in message
...
thanks. this one worked.

"Nigel" wrote in message
...
Try putting this into your UserForm initialize event.......

Application.WindowState = xlMaximized
Me.Width = Application.Width
Me.Height = Application.Height

Regards,
Nigel


"Takashi Yamauchi" wrote in message
...
Could anyone give me a suggestion?

As I open a UserForm, I want to maximize the size of the form (making it
as large as my monitor). In the VB6 Form property, there is a property
called "WindowState" and I can select "Maximized." But, I can't find a
similar property in Excel VBA. How can I automatically maximize a
UserForm in Excel VBA?

Thank you

Takashi Yamauchi