How to minimize a form using VB

[Jean Oct]

Hi,

How to minimize a form during startup?

Public Sub Workbook_Open()

Userform.show

.......

Many Thanks,
Jean.

 

[Bob Phillips]

Jean,

If you use Load rather than Show it won't be immediately displayed, but will
be loaded into memory. Then you can Show it later when you are ready.

 

[Bob Phillips]

Jean,

Sorry, but I don't understand the question. If it's minimized, it is not
showing is it?

If, as I guess you must be, are referring to not having a minimize and
maximize button on a form, then this requires API calls. Stephen Bullen
demonstrates the technique I believe in his FunForm example at
http://www.bmsltd.co.uk/Excel/Default.htm