Condensing my Code - Changing Multiple Oval Color

**Miricleman** · 05-08-2016, 07:28 PM

Hi,

I have some code that I have written that changes the shade of some ovals in my "Overview" sheet when a calculation in the "Log" sheet is updated. It currently works, however I have 105 ovals labelled "Oval1 to Oval105" in the Overview sheet I want to change when the calculation in row "1001" for each column from D to DM changes (eg. Column D = Oval1 Column DM = Oval105).

How can I make the code simpler below for all the ovals etc without having to do the code for each Oval?

Please Login or Register  to view this content.

Thank you

**Crooza** · 05-08-2016, 09:57 PM

Without your worksheet its a bit awkward but maybe something like this that steps through 105 steps using the offset to pick the new column each time and changing the oval name sequentially

Please Login or Register  to view this content.

**Miricleman** · 05-08-2016, 10:39 PM

Hey Crooza,

Works a treat, bloody clever really never thought about a combination "Oval" & i . Will keep this in mind for future projects.

Thanks

**Crooza** · 05-08-2016, 10:48 PM

Mate - glad it worked. I had nothing to test it on so I was flying blind.

Condensing my Code - Changing Multiple Oval Color

LinkBack

Thread Tools

Rate This Thread

Display

Condensing my Code - Changing Multiple Oval Color

Re: Condensing my Code - Changing Multiple Oval Color

Re: Condensing my Code - Changing Multiple Oval Color

Re: Condensing my Code - Changing Multiple Oval Color

Thread Information

Users Browsing this Thread

Similar Threads

Code for changing cell color

Click oval check buttons to fill and unfill color

[SOLVED] Click oval option button to fill/unfill color, also change border color to match fill

Cell color is not changing through vba code

[SOLVED] varying number of columns, multiple similar lines of code (needs condensing)

Condensing Repetitive Code Distributed to Multiple Sheets

WordArt - changing text color in code

Bookmarks

Bookmarks

Posting Permissions