Application.volatile not working

[Greed]

Hi all,

I have a piece of code in a workbook (module 2) to change the colour of certain text when selected from a drop down list. Sometimes the colour changes, sometimes it doesn't it seems pretty random. I want the colour to change as soon as it's selected, I don't want to have to run the macro manually Here is the code:

Please Login or Register  to view this content.

So, if I select "OT" in cell B6, the colour changes - great...but if I select "OT" in cell B10 - nothing. Not sure where I've gone wrong but any help would be appreciated. Workbook attached
TIA

[shg]

Application.Volatile is used to make a user-defined function recalculate any time the Excel application calculates -- it's not relevant to a sub.

You'd need to call the sub from the Calculate event.

[OnErrorGoto0]

You could add this to your Change event code after the last End If

Please Login or Register  to view this content.

(untested)