Cell Update on Data Validation Selection

I'm using a DV List (in H100) to allow the user to select various options. If one particular option is selected from the DV List, I need to dispaly text in cell H98, which I'm doing using this code:

Please Login or Register  to view this content.

However, cell H98 won't show the text until cell H100 is not selected, i.e. until another cell is clicked. The same applies to clearing the cell as well.

Question
How can I get my text to appear as in H98 as soon as the relevant option is selected from the DV List without the user having to click another cell?

Hi Jeff,

This works perfectly, though I need to extend the code across ten columns as there is a DV List in each column and the value "Total" can be selected from any of them. I tried to extend your code to allow this to work for each column, what am I doing wrong? (I've only tried to add the second column below).

Please Login or Register  to view this content.

Jeff,

That works perfectly, many thanks once again for your help...