View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Takashi Yamauchi Takashi Yamauchi is offline
external usenet poster
 
Posts: 7
Default maximizing the size of a UserForm

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