theluggageofmanylegs
New Member
- Joined
- Jul 29, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi folks,
First time poster here - apologies if I get anything wrong etiquette-wise.
I have a worksheet that has 7 either/or questions at the top for the user to answer, with two buttons associated with each - think "Used"/"Not Used". Based on the button that the user clicks, a macro is run to autopopulate certain cells and show/hide specific rows.
I'm trying to think ahead and code for a situation where someone skips right past my lovely formatted buttons and decides to answer the questions from the get-go. I know I can trigger my macros to run using Worksheet Change events - my question is, is it very messy to do this for the 14 different situations (7 questions x 2 answers) in one sub, as each will have different things to do? I'm assuming it isn't possible to do separate worksheet change subs - if so, please excuse my ignorance, still figuring all of this out!
First time poster here - apologies if I get anything wrong etiquette-wise.
I have a worksheet that has 7 either/or questions at the top for the user to answer, with two buttons associated with each - think "Used"/"Not Used". Based on the button that the user clicks, a macro is run to autopopulate certain cells and show/hide specific rows.
I'm trying to think ahead and code for a situation where someone skips right past my lovely formatted buttons and decides to answer the questions from the get-go. I know I can trigger my macros to run using Worksheet Change events - my question is, is it very messy to do this for the 14 different situations (7 questions x 2 answers) in one sub, as each will have different things to do? I'm assuming it isn't possible to do separate worksheet change subs - if so, please excuse my ignorance, still figuring all of this out!