Copy command button in message box

Closed
MUKUL_1308 Posts 8 Registration date Friday June 15, 2018 Status Member Last seen July 5, 2018 - Updated on Jul 2, 2018 at 01:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 5, 2018 at 11:35 AM
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.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 3, 2018 at 11:59 AM
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
0
MUKUL_1308 Posts 8 Registration date Friday June 15, 2018 Status Member Last seen July 5, 2018
Jul 5, 2018 at 01:47 AM
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..
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 5, 2018 at 11:35 AM
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
0