how to copy and paste text from msgbox

J

Joy

I want to put some text infor(URL) in msgbox and let user copy and paste. how
can I do that?

thank you
 
J

John

Joy said:
I want to put some text infor(URL) in msgbox and let user copy and paste. how
can I do that?

thank you
Click to expand...

Joy,
I haven't actually tried this but try putting the text as the default
text for an InputBox instead of a MsgBox. The user should be able to
copy it but may have to wait for the VBA code to finish before the
copied text can be pasted into another application.

John
Project MVP
 

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 to paste this down? 3
Paste to excel from word - auto format problem 1
How to make repeating drop-down lists? 2
Create a dynamic master file 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Visio shape text disappears upon copy paste 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Copy/Paste (Clipboard) Issues 1

Top