Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Spredasheets
i have also got a userform on the side running in paralel with my
spreadsheet But the thing is i cant use my spread sheet unless i close down my userform anyone know a way i can use both these in conjunction with each other? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Spredasheets
What version of Excel are you using? In Excel 2000 and later, you
can show the form "modelessly", which will allow you to switch between the worksheet and the form. Use the following code to show the form: Userform1.Show vbModeless -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DaveyB" wrote in message ... i have also got a userform on the side running in paralel with my spreadsheet But the thing is i cant use my spread sheet unless i close down my userform anyone know a way i can use both these in conjunction with each other? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Spredasheets
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Spredasheets
See ModelessForm at Stephen Bullen's page
http://www.bmsltd.co.uk/Excel/Default.htm -- HTH. Best wishes Harald Followup to newsgroup only please. "DaveyB" wrote in message ... excel 97 and thxn for your help --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Userforms | Excel Discussion (Misc queries) | |||
I need some help with userforms | Charts and Charting in Excel | |||
I need some help with userforms | Excel Discussion (Misc queries) | |||
Userforms | Excel Programming | |||
Userforms | Excel Programming |