How to pause a Macro

Posted by Joe C on December 11, 2001 9:26 AM

How can I pause a Macro and allow the user to copy text to the clipboard?
The first question asks him if hed like to copy text.
I then want to tell him with next message, to copy to clipboard, and then press continue. But the boxes wont the message box demands an answer before anything else can be done. Is there a different message box style? Thanks for any help.

Posted by Jacob on December 11, 2001 2:21 PM

This might help

Try this

Dim MyRange

myrange=inputbox("What range do you want to copy to the clipboard? For example type a1:c15 do not use quotations")
range myrange.select
select.copy

Hope this gets you started.

Jacob