Automation help with VBA

[ChadCnnnghm]

So I have a selection change that checks the string in a data validation drop down box and changes a tables values. My first issue is that it only changes after I select my value of the drop down then click the cell again. How can I make it so it changes the table when i just select the drop down value.

Next I have a number of macros that calculate prices in the table. How do I get these to automatically run when the drop down is changed.

Thanks in advance.

 

[Norie]

Use Change instead of SelectionChange.

Call the other macros from the Change event.

 

[ChadCnnnghm]

Thanks! Worked like a charm and loads simpler then other methods I have seen online.

Just for clarification, what is the difference between change and select change?

 

[Norie]

It's kind of in the name, SelectionChange is triggered when the selection on the sheet changes and Change is triggered when a change is made on the sheet.

 

[ChadCnnnghm]

Okay, I thought so, just wanted to make sure, as my I chose to use SelectionChange based on somone's suggestion.