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/