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.


"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