Run Macro when Drop Down value selected

[fangfacekitty]

I need to have my Fx macro run whenever a value is chosen from the drop down list in cell K9. I know I have seen how to do this but for the life of me I can't find a thread today that contains this info. The actual value chosen does not matter, I just need the macro to run every time the value in the cell changes.

On the template cell K9 is blank. So when the user chooses a EUR from the drop down the macro should run automatically (the user shouldn't have to do anything). And if the user then decides to change the currency to USD the macro should run again automatically.

Thanks in advance for your help!

 

[gdesreu]

Do you mean attach the code to combo box to call the macro? If so I would just do something like

Private Sub combobox1_Change()
Call FX
End Sub

 

[gdesreu]

or you could right click your sheet tab that contains the pulldown and hit "view code" then

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range
   Set KeyCells = Range("k9")
   Call fx
  
   End Sub

 

[fangfacekitty]

Thanks for the response. The drop down is actually a data validation list, not a control box.

 

[gdesreu]

Thanks for the response. The drop down is actually a data validation list, not a control box.

ok then my second post should work for a validation list. Ive needed to do the same exact thing recently with a validation list.

 

[fangfacekitty]

ok then my second post should work for a validation list. Ive needed to do the same exact thing recently with a validation list.

Thanks again, it works great!

 

[gdesreu]

You're quite welcome.