Forum Discussion
Excel active X button s
I want to have multiple active X buttons in groups as way of entering data. I will have one pressed in each group. Possibly more but lets say 3 to start.
Lets say its employees, I press employee steve
second group is department, I press HR
I press a button in 3rd group, its shifts, I press dayshift.
After I press 3rd group, an entry goes into a data sheet that increments (steve - HR - dayshift) + 1.
Is that better suited on a form of some sort?
- Personally, I would strongly prefer to use Data Validation (using the "List" type) drop-downs directly in cells. Design-wise this is also a lot easier to manage.
