Any way to copy/paste from Msgbox ?

[David]

Is there any way to copy and paste the contents of a
MSGBOX?
I'm debugging a system and I have a long SQL that I build
in VBA. I displayed it in a MSGBOX. Now I need to copy it
to a query and see if it runs. But how?

 

[Rick Brandt]

Is there any way to copy and paste the contents of a
MSGBOX?
I'm debugging a system and I have a long SQL that I build
in VBA. I displayed it in a MSGBOX. Now I need to copy it
to a query and see if it runs. But how?

Instead of displaying it in a MsgBox use Debug.print to send it to the
debug window. Then you can copy n' paste from there.