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