show the form as minimized window

  • Thread starter Thread starter Jean Oct
  • Start date Start date
J

Jean Oct

Then if I want to show the form as minimized window
state , can I do so using VBA?
 
I dont think you can. but you can change the size and posisiton so it looks
like a minize window.


If UserForm1.Height > 30 Then

UserForm1.Height = 30
UserForm1.Left = 494
UserForm1.Top = 525
Else

UserForm1.Height = 180
UserForm1.Left = 258.5

UserForm1.Top = 203

End If

also make it modeless so you can work on the sheet while the form still
open.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Form Show 4
VB6 form show Minimize button 2
Is there a fancy way to open a workbook in a minimized window stat 2
How to stop Stephen Bullen's CFormChanger from minimizing as an MDItitle bar? 7
Code to Minimize the riboon 3
Activate Sheet but minimize Userform 1
Excel VBA in Citrix. 0
Minimize the ribbon in Excel 2007 using code 1

Back
Top