| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show the form as minimized window
Then if I want to show the form as minimized window
state , can I do so using VBA? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel VB - show userform1 (at same time) minimized application win | Excel Discussion (Misc queries) | |||
| Why do minimized workbooks in Excell not show file names? | Excel Discussion (Misc queries) | |||
| Why do minimized workbooks in Excell not show file names? | Excel Discussion (Misc queries) | |||
| Help window opens minimized | Excel Discussion (Misc queries) | |||
| How to keep window + form activate together | Excel Programming | |||
Linear Mode
