Use VBA and Active X check boxes to copy info to another worksheet (1 Viewer)

Autoeng

Why me?
Local time
Today, 14:20
Joined
Aug 13, 2002
Messages
1,302
Good afternoon,

It's been years since I've been on the forum and just as long since I've used VBA so I'm starting from scratch on a project.

I'm looking for a way to use VBA and Active X check boxes to move info from one worksheet to another in the same spreadsheet.

In my example I'm taking an order for a sandwich. Select the bread, the meat, and the condiment from the Ingredients worksheet and the selections are copied to the Order worksheet.

I would like for the move to be immediate when a checkbox is selected instead of having to select an action button. Therefore whenever the status of a checkbox is changed the entire Ingredient spreadsheet is run through again. If an ingredient is selected and then removed that should be accounted for as well by deleting the item from the Recipe spreadsheet.

Thank you for your help or direction to finding a solution to this project.
 

Attachments

  • CheckBoxSelect.xlsx
    14.6 KB · Views: 118

Autoeng

Why me?
Local time
Today, 14:20
Joined
Aug 13, 2002
Messages
1,302
Hi everyone,

I'm continuing to struggle with this project. I "think" it can be done but maybe it can't and I'm wasting time and effort in trying to figure it out. Anyone?
 

Users who are viewing this thread

Top Bottom