RefEdit - cannot select range on another workbook

R

Rob

I have created a Userform in VBA with a RefEdit control.
I want to select a range in another workbook, but this
does not seem possible. Any ideas?
 
J

Jon Peltier

Rob -

You can use Ctrl-Tab to switch among workbooks with the form open.
Alternatively, you could populate a list box or combo box with the names
of the open workbooks, and let the user switch workbooks this way.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top