Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

**realbestpete** · 01-31-2021, 02:41 AM

Hi everyone,

I have been trying to loop through a range of cells and if they have a value different to blank, they should trigger the change of their respective row in another column that contains checkboxes to set their corresponding row value to True. I would require this to be done through the Worksheet Change Event so that every time there is new data input, the formula changes value and then the code gets executed. I have tried everything and now Excel just keeps on restarting every time if I try something new so any help would be greatly appreciated!

I have attached a sample spreadsheet to show what I mean.

**maniacb** · 01-31-2021, 07:44 AM

Try

Please Login or Register  to view this content.

**realbestpete** · 01-31-2021, 03:01 PM

Thank you very much maniacb, I tried your code and it works just fine!! As I think coding is important as part of a learning process, I would like to leave the Thread open for a couple of days if that is not against the rules just to see if anyone comes up with a different approach, which would be interesting as I said for learning! Cheers!!

**Fluff13** · 01-31-2021, 03:16 PM

Another way, using column to define the last row

Please Login or Register  to view this content.

This may need a slight tweak to work with Xl 2013

**Fluff13** · 01-31-2021, 03:25 PM

Just realised that col E is formulae, this will run when you change a value in col C

Please Login or Register  to view this content.

**realbestpete** · 02-02-2021, 12:49 AM

Unbelievable, it also worked and it's a third shorter! Thanks mate!

**Fluff13** · 02-02-2021, 08:47 AM

Glad to help & thanks for the feedback.

Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

LinkBack

Thread Tools

Rate This Thread

Display

Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

Re: Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

Re: Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

Re: Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

Re: Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

Re: Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

Re: Loop Through Range to change CheckBoxes Value in A Conditional Using Variables

Thread Information

Users Browsing this Thread

Similar Threads

Change variables on every second loop

Loop Through List to Change Variables

Nested For Each loop for 2 range variables

Mutiple Checkboxes using SetCheckBoxes Function to change state of several checkboxes

[SOLVED] Applying Conditional Formatting to a Range in VBA (range is set by variables)

change the range on autofill to use defined variables

Select Range using variables-used a For Next Loop

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions