Minimize excel user form

[Guest]

How do I minimize the user form? I need a button(or something) but can't find
it in properties. Also when the user form is on the screen the rest of excel
does not function until I close the user form. I need both at the same time
to be available.
I'm rather new..
Thanks
Gary
I hope I'm not reposting this....not sure the first try when through..

 

[Guest]

Hi,

You may helpfull is visit : www.oaltd.co.uk

and download FormFun.Zip ..

Thanks,
Halim

 

[Duncan]

Hammer:

Definately go to www.oaltd.co.uk and get FormFun, an invaluable
learning tool in my opinion.

Duncan

 

[Norman Jones]

Hi Hammer,

You have received suggestions in respect of the first (minimize button) part
of your question.

Also when the user form is on the screen the rest of excel
does not function until I close the user form. I need both at the same
time
to be available.

Try:

'=============>>
Public Sub Tester()
UserForm1.Show vbModeless
End Sub
'<<=============

 

[bart.smissaert]

Look at the thread: Minimize Maximize buttons of 7 July in this NG.
All you need will be in there.

RBS

 

[Guest]

Thank you very much for the info..I didn't know this forum existed...this is
now part of my library...
gary