Minimize excel user form
 

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..

Minimize excel user form
 

Hi,

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

and download FormFun.Zip ..

Thanks,
Halim

"Hammer1947" wrote:

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..

Minimize excel user form
 

Hammer:

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

Duncan


Halim wrote:

Hi,

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

and download FormFun.Zip ..

Thanks,
Halim

"Hammer1947" wrote:

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..

Minimize excel user form
 

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
'<<=============



---
Regards,
Norman


"Hammer1947" wrote in message
...
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..

Minimize excel user form
 

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

RBS

Hammer1947 wrote:
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..

Minimize excel user form
 

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

" wrote:

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

RBS

Hammer1947 wrote:
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..