View Single Post
  #6   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?

Thanks for the reminder, Ron. I'm in XP and my friend is using either XP or
2000, so we're okay.

Ed
PS - I use your Google search add-in several times a week. It has saved my
bacon many times.

"Ron de Bruin" wrote in message
...
This is not working in excel 97 Ed.

If you have users that use this version then you can't open the userform

like this.

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ed" wrote in message

...
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