View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Maxson Charles Maxson is offline
external usenet poster
 
Posts: 24
Default Click on worksheet with UserForm open?

Ed,

You could set the form's ShowModal property to false and the user can still
move the cursor with your form showing...

--
Charles
www.officezealot.com


"Ed" wrote in message
...
My macro works and the Form looks okay for a beginner. But if the user
doesn't have the correct cell selected before launching the UserForm, can
I
allow him to click on the worksheet to select a different cell without
having to close the form and relaunch?

Ed