Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to minimize a userform!
i'm not able to set 'minimize' & 'maximize' - window property on
userforms. Is it possible to do that on VB excel or not? in particular i have an userform "working" with data inside a worksheet. if i change something inside userform i want to verify what's changed in related worksheet too.... but there's no way to minimize the userform "activating" the sheet selection. so i have to close (userform.hide) the userform, to "reactivate" the worksheet. What to do ?? thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to minimize a userform!
You could set the form property
ShowModal = False This will allow you to activate the worksheet and move around it. You could incorporate an event in the form that will return the cell(s) value(s) to the form. I sometimes do this by having the form return a value to a label on the form. You could have the form event scroll the worksheet and place the cell(s) in question to a viewable position. -- steveB Remove "AYN" from email to respond "furbiuzzu" wrote in message ups.com... i'm not able to set 'minimize' & 'maximize' - window property on userforms. Is it possible to do that on VB excel or not? in particular i have an userform "working" with data inside a worksheet. if i change something inside userform i want to verify what's changed in related worksheet too.... but there's no way to minimize the userform "activating" the sheet selection. so i have to close (userform.hide) the userform, to "reactivate" the worksheet. What to do ?? thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to minimize a userform!
Hi Try the following; Dim dWidth As Double Private Sub ToggleButton1_Click() If ToggleButton1.Value = True Then Me.Height = Me.Height * 0.25 Else Me.Height = dWidth End If End Sub Private Sub UserForm_Initialize() dWidth = Me.Height End Sub Lenny -- Lenny_821 ------------------------------------------------------------------------ Lenny_821's Profile: http://www.excelforum.com/member.php...o&userid=15179 View this thread: http://www.excelforum.com/showthread...hreadid=379394 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to minimize a userform!
Hi Furbiuzzu,
See the following post from Michel Pierron: http://tinyurl.com/deqwf --- Regards, Norman "furbiuzzu" wrote in message ups.com... i'm not able to set 'minimize' & 'maximize' - window property on userforms. Is it possible to do that on VB excel or not? in particular i have an userform "working" with data inside a worksheet. if i change something inside userform i want to verify what's changed in related worksheet too.... but there's no way to minimize the userform "activating" the sheet selection. so i have to close (userform.hide) the userform, to "reactivate" the worksheet. What to do ?? thanks in advance! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to minimize a userform!
It may be a bit too much trouble for your purpose, but a good option is to
use a VB6 form. They are much more like normal windows, so can minimize/maximize, have copy and paste in textboxes, have a listboxes that can scroll with the mouse wheel etc, and all this without any API calls. You can pick up a copy of VB6 Pro from EBay for about £200 RBS "furbiuzzu" wrote in message ups.com... i'm not able to set 'minimize' & 'maximize' - window property on userforms. Is it possible to do that on VB excel or not? in particular i have an userform "working" with data inside a worksheet. if i change something inside userform i want to verify what's changed in related worksheet too.... but there's no way to minimize the userform "activating" the sheet selection. so i have to close (userform.hide) the userform, to "reactivate" the worksheet. What to do ?? thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimize button on userform? | Excel Discussion (Misc queries) | |||
Minimize UserForm | Excel Discussion (Misc queries) | |||
Minimize a UserForm | Excel Discussion (Misc queries) | |||
VBA userform with minimize button | Excel Programming | |||
COM add-in userform minimize button | Excel Programming |