Run Macro when indirect cell reference changes

[Holbeck_Ghyll]

Hi,

I'm fairly new to Visual Basic, so apologies if this is fairly simple.

I currently have a macro (named Macro1) that relies on information from two dropdowns to pull out a named range from a big dataset. The linked cells from the two drop downs are referenced by another cell which combines them, and this is used as the reference for the Macro.

Ex - Drop down 1 is linked to C4 and Drop down 2 is linked to F4. The formula in H4 is = C4 & " " & F4 , and this is the cell which I want the macro to respond to.

How do I get the macro to run whenever each drop down is changed? Any help would be very much appreciated.

[AlphaFrog]

Right-Click on both DropDowns and assign Macro1 to each. That will trigger Macro1 when either DropDown is changed.

Macro1 can still respond to the value in H4 within its' code or it could combine C4 and F4 itself.

[Holbeck_Ghyll]

Thanks very much.