Userform

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey guys

How do I make a userform come up and still be able to do
things in Excel like change cell values and so on without
having to close the userform first?



Todd
 
You can do this in Excel 2000 and later.

UserForm1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks. Is there anyway to make it go behind other
windows?
 
Also why does this not talk about vbModeless in the help
file?
 
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

Userform - Title bar formatting options and other attributes 2
Userform textbox string to header causes unwanted double spacing 4
Excel Excel 2007 fails on insert userform 0
closing another file by code causes failure to run workbook activate event 2
how to reshow userform after following a link 1
Worksheet appears briefly before UserForm opens 4
UserForm show mode 4
saving the userform layout 0

Back
Top