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

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
 
Top