View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ed[_23_] Ed[_23_] is offline
external usenet poster
 
Posts: 15
Default Click on worksheet with UserForm open?

Thank you, Charles! That did the trick.

Ed

"Charles Maxson" wrote in message
...
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