Userforms and Spredasheets

  • Thread starter Thread starter DaveyB
  • Start date Start date
D

DaveyB

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?
 
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
 
Back
Top