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