Selectable Text in VBA Message Box

Question

When I create a msgbox in VBA, the user cannot interact with the text at all. In my case, I want the user to be able to highlight and copy the text. I'm thinking the better way to do this may be to add a button that copies the text to the clipboard. Any suggestions?

Answer 1

For this code:

msgbox "Does Control+C work on a lowly, old message box?" 

you can press ctrl + c, open notepad, ctrl + v and you will get this:

--------------------------- Microsoft Excel --------------------------- Does Control+C work on a lowly, old message box? --------------------------- OK    --------------------------- 

Answer 2

You can use an inputbox instead of a message box

inputbox "Copy the below text", "Copy Text", "Text value" 

inputbox copy text