Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimizing a Form
Am I dense or am I missing something? I can't find the controls box to
minimize a userform in excel vba XP on a win2k system. -khai |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimizing a Form
As far as I know you can not minimize the form. Do you need the form to
stay open while working on the sheet? then you may try to use the modeless function? for the form. Sub showform() UserForm1.Show modeless End Sub or may be you can write a code to resize the form when you double click on it or a button Private Sub UserForm_DblClick(ByVal Cancel As MSForms.ReturnBoolean) 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 End Sub Cesar Zapata Cesar Zapata "Khai" wrote in message news:McWTa.136947$ye4.95763@sccrnsc01... Am I dense or am I missing something? I can't find the controls box to minimize a userform in excel vba XP on a win2k system. -khai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimizing Rows of with similar data | New Users to Excel | |||
Minimizing Jpegs withing an excel sheet | New Users to Excel | |||
Minimizing number of commands | Excel Discussion (Misc queries) | |||
Minimizing excel window grays it out on taskbar | Excel Discussion (Misc queries) | |||
minimizing problem | Excel Discussion (Misc queries) |