Copy text to clipboard based on CheckBox value on Command Button click

**askpcguy** · 07-16-2014, 12:48 AM

First off I want to express my sincere gratitude for those kind enough to lend me a hand with this problem. I'm beyond a novice with Excel VBA.

In Excel 2010, I have a user form with 9 checkboxes and a command button. When the command button is pressed, text is copied to the clipboard based on the value of the checkboxes. For example, checkboxes 1 and 2 are True (checked) and the others are False (unchecked). Pressing the command button will copy the checklist to the clipboard saying "Steps 1 and 2 are Done, Steps 3-9 are NOT DONE!".

The ideal checklist copied to the clipboard will call out each step of the 9 steps. As an example in a list format:
"Step 1 Done
Step 2 Done
Step 3 NOT DONE
~Step 9 NOT DONE"

I've been searching for any kind of examples/sample code that might help me acheive this but thus far have not been successful.

Please let me know if any additional information is required, the VBA I have now is brutal and unsafe for human consumption!

**Domenic** · 07-16-2014, 05:17 AM

First, for each checkbox enter the step number in its Tag property. So, for CheckBox1 enter Step 1 in its Tag property, for CheckBox2 enter Step 2, etc. Then try...

Please Login or Register  to view this content.

Hope this helps!

**askpcguy** · 07-16-2014, 06:15 PM

Hello Domenic! Thank you for replying. The code really helped, had to make some minor adjustments but I think things look good. Here's the final code I ended up with. This is all in the UserForm1 code.

Please Login or Register  to view this content.

**Domenic** · 07-16-2014, 09:01 PM

Actually, since you already have a reference to the Microsoft Forms Object Library, you can amend the code as follows...

Please Login or Register  to view this content.

Hope this helps!

**askpcguy** · 07-17-2014, 01:21 AM

I was wondering what that CreateObject did! I didn't have time to go look up what that was but since it accomplished my goal I left it. Here's the final code which does everything that we need.

Thanks again Domenic! Now I'm looking into porting over the VBA into Visual Studio to build a standalone executable since the VBA does not interact with Excel.

Please Login or Register  to view this content.

Copy text to clipboard based on CheckBox value on Command Button click

LinkBack

Thread Tools

Rate This Thread

Display

Copy text to clipboard based on CheckBox value on Command Button click

Re: Copy text to clipboard based on CheckBox value on Command Button click

Re: Copy text to clipboard based on CheckBox value on Command Button click

Re: Copy text to clipboard based on CheckBox value on Command Button click

Re: Copy text to clipboard based on CheckBox value on Command Button click

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Command button to copy data from WB1 to WB2 based on selected value in WB2 vba

use a command button to click other command buttons

Click Command Button, run macros based on cell value

Get Command Button Caption on Click & Log to Text File

Copy cell value to list with command button click

Bookmarks

Bookmarks

Posting Permissions