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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel 2007 fails on insert userform 0
Userform - Title bar formatting options and other attributes 2
closing another file by code causes failure to run workbook activate event 2
Paste into spreadsheet in userform 2
Cut and paste objects into userforms 8
Userform hide help 1
how to reshow userform after following a link 1
Userform with commandbar popup 2

Back
Top