Click on worksheet with UserForm open?

[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

 

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

 

[Ed]

Thank you, Charles! That did the trick.

Ed

Ed,

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

 

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

 

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

 

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