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!

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!

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

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!

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!