Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimize user form | Excel Programming | |||
Minimize Form | Excel Programming | |||
How do I create minimize and restore buttons on a user form | Excel Programming | |||
How to minimize a form using VB | Excel Programming |