Selecting ranges with a text box

E

Ed

Bob,

You can add a UserForm and set it's ShowModeal to False.
This will allow the user to copy from cells while the
form remains open.
 
B

Bob Metzler

Thanks for your help. This works for cutting and pasting data into a
textbox, but I was hoping to have the address of the range input
automatically when I selected it on a worksheet, similar to the inputbox
control with type=8. It appears that refedit will work, although it
does look a bit different than the inputbox dialog box.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 

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

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Word macro that can call cells out of Excel for a find and replace 0
Macro to Select text from a point given to a specific word 2
AppleScript - How do I select a text ? 1
Can you check a show modal property 6
Print Preview Office 2007? 4
ShowModal, Hide Form, Print Preview Office 2007 2
Restrict access to only one sheet 4

Top