I have a dropdown on my worksheet that allows a user to pick the correct shelf number and it changes the number in the sentence in column I.
The next row has 9 Checkboxes that I want the user to click. True it changes the last word in the sentence to up. False it changes it to down.
I recorded a macro to do this but I know there is simpler code for these 9 check boxes. I am also afraid after a while the macro will crap out on me.
If the user checks box 1 i need it to change the rows in column I that have to do with C1 and L1
2 changes C2 and L2
3 changes C3 and C4.
I am not that great at setting up code to loop through a worksheet yet.
Any help is greatly appreciated.
Thank you