PDA

View Full Version : Solved: Minimize user form



blackie42
11-20-2007, 01:57 PM
Hi - was wondering if theres any way to minimise a user form?

I have a command button that closes/hides the form but can a cmdbutton be used to minimise to tray?

thanks

blackie42
11-20-2007, 03:55 PM
Found this but doesn't min to tray

Private Sub ToggleButton1_Click()
If ToggleButton1.Value = True Then
Me.Height = Me.Height * 0.25
Else
Me.Height = dHeight
End If
End Sub

Private Sub UserForm_Initialize()
dHeight = Me.Height
End Sub

asingh
11-20-2007, 05:17 PM
Hi,

I had used a solution from here (http://www.xcelfiles.com/Userform_TaskBar.html)..the form would minimize to the bottom..!

regards,

asingh

blackie42
11-21-2007, 04:17 AM
Thanks - seen that but its a little complicated to see what bits I need for
my own project. I did try but kept getting 'can't execute break in code' errors.

asingh
11-21-2007, 04:21 AM
post your workbook....can integrate it for your form. Specify on which forms you want the minimize functionality...?

blackie42
11-21-2007, 11:55 AM
Unfortunately the file is bigger than the limit of 241Kbs

thanks for the offer anyways

blackie42
11-21-2007, 04:07 PM
I'll mark as solved

Ivan F Moala
11-22-2007, 04:52 AM
Is it solved ?

Specifically what did you get stuck on ?
If you can send me the work book then perhaps I can help