Any way to copy/paste from Msgbox ?

  • Thread starter Thread starter David
  • Start date Start date
D

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?
 
David said:
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.
 
Back
Top