How to minimize a userform!

[furbiuzzu]

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!

 

[STEVE BELL]

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.

 

[Lenny_821]

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

 

[Norman Jones]

Hi Furbiuzzu,

See the following post from Michel Pierron:

http://tinyurl.com/deqwf

 

[RB Smissaert]

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