View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cesar Zapata[_2_] Cesar Zapata[_2_] is offline
external usenet poster
 
Posts: 66
Default show the form as minimized window

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.
"Jean Oct" wrote in message
...
Then if I want to show the form as minimized window
state , can I do so using VBA?