VBA to automatically calculate when cell color changes tied in with other VBA's

**Smiffy3594** · 05-13-2024, 09:49 AM

I have a spreadsheet with a couple of VBA's and one module but the last thing I am trying to do is not working I picked up the VBA and module via you tube video and majority of it works fine

attached file :
column B is generated when column C has input
when something has been actioned it will be manually shaded yellow in E9 to G16 and the total of each column will show on row 5 and those still to action not shaded total shows in row 6, but it will only update the totals if you re-edit the formula !

So then I tried to follow the automatically update totals should a not shaded cell then be shaded yellow from a tutorial on the youtube video "https://www.youtube.com/watch?v=OrAvtXI8zVw" this part is 8:11 in the video and I added the following VBA to the existing VBA's on the "Sheet1 (Sheet1)" under the existing end sub text - but I get an error message "Compile error : ambiguous name detected: Worksheet_SelectionChange"

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("e:g")) Is Nothing Then
ActiveSheet.Calculate
End If
End Sub

what am I missing / doing wrong

Am using Microsoft Office Professional Plus 2019

**6StringJazzer** · 05-13-2024, 09:57 AM

You already have sub Worksheet_SelectionChange declared for that sheet. You cannot add another sub with the same name.

Perhaps modify your existing sub to incorporate the additional functionality:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.