LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform to size to display Jason V[_2_] Excel Programming 2 August 17th 07 02:06 AM
UserForm Size On Different Computers Minitman[_5_] Excel Programming 11 December 7th 06 04:22 PM
Print UserForm A4 size SZ Excel Programming 1 January 26th 05 10:03 AM
Print UserForm A4 size SZ Excel Programming 0 January 24th 05 07:07 AM
Userform Size Richard Excel Programming 1 May 27th 04 12:16 PM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"