Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Copy command button in message box [Closed]

Report
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
 -
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
 -
Hello,

I want to create copy command button through message box in VBA.
In message box the information which is going to reflect should be copied to clipboard when i click copy button.
please help me for this.
See more

1 reply

Answer 1 / 1
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
 455
Hi Mukul,

I'm a little confused by your query.

The information displayed by a message box is inputted through VBA, so you can already copy it to the clipboard. Also a message box will only have a 'OK' button.

Can you explain in greater detail what you are trying to accomplish?

Best regards,
Trowa
Report
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
sir,
actually I had created a userform and while compiling the input data I assigned data with predefined templates in msgbox. please tell me if there is a way so that i can copy the whole msgbox with a single click..
Report
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
 455
Hi Mukul,

So you created a userform where you input data, ok.
You assigned that data to specified locations on a template, ok.
In msgbox??? You lost me there.

Do you mean that instead of placing the data in the template, you put it in a msgbox? And now you want to copy from the msgbox to the template?

Am I understanding you correctly?

Best regards,
Trowa
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!