Autoeng
Why me?
- Local time
- Yesterday, 20:58
- 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.
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.