The VBA method for resizing the UserForm is Move Method(Forms). The help
file does not give a lot of information on it, but width and height are
arguments to the move command for the UF.

"Takashi Yamauchi" wrote:

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