New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Checkbox loop to change value at end of sentence

Macros, VBA, Excel Automation, etc.

Checkbox loop to change value at end of sentence

Postby laurensims41 » Tue Sep 27, 2016 5:27 pm

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
  • 0

You do not have the required permissions to view the files attached to this post.
laurensims41
Rookie
 
Posts: 15
Joined: Feb 3, 2016
Reputation: 0
Excel Version: Office Professional Plust 2010

Checkbox loop to change value at end of sentence

Postby FrankgexGuru » Fri Dec 23, 2016 6:53 am

I see... is there any way of achieving my goal then?
Any way to change the main light if thats the one that is used in the saving procedure?

Thank you.

Francesco
  • 0

FrankgexGuru
Rookie
 
Posts: 1
Joined: Dec 17, 2016
Location: Madagascar
Reputation: 0
Excel Version: 2007


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 9 guests