How to run a macro that selects options from combobox

Copper Contributor

Hello, I am working on a project where I need to have a macro that selects options from multiple combo boxes and then adjust information that was updated depending on which options were selected. The problem is that I do not know how to get the macro to respond to the selection. When I open VBA and select an option from the drop down menu nothing shows up. Please help. I have tried researching it but everything is about running a macro from a drop down box, not actually changing the selection of a drop down box from the macro.

3 Replies
Which type of ComboBox it is?

@Subodh_Tiwari_sktneer 

 

Its a data validation list

In that case, you should use Sheet Change Event Code. Did you try that?