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:

If Range("$H$100").Value = "Total" Then
    Range("$H$98").Value = "£'s Thousands"
Else
    Range("$H$98").ClearContents
End If
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?