Click on worksheet with UserForm open?

E

Ed

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
 
C

Charles Maxson

Ed,

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

Ed

Thank you, Charles! That did the trick.

Ed

Charles Maxson said:
Ed,

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

Ron de Bruin

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

Tim

i think you could use the RefEdit activeX control, and select the range in
th same way that you can with the function builder on a worksheet.
 
E

Ed

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