How to run a macro that selects options from combobox

%3CLINGO-SUB%20id%3D%22lingo-sub-2557936%22%20slang%3D%22en-US%22%3EHow%20to%20run%20a%20macro%20that%20selects%20options%20from%20combobox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2557936%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20working%20on%20a%20project%20where%20I%20need%20to%20have%20a%20macro%20that%20selects%20options%20from%20multiple%20combo%20boxes%20and%20then%20adjust%20information%20that%20was%20updated%20depending%20on%20which%20options%20were%20selected.%20The%20problem%20is%20that%20I%20do%20not%20know%20how%20to%20get%20the%20macro%20to%20respond%20to%20the%20selection.%20When%20I%20open%20VBA%20and%20select%20an%20option%20from%20the%20drop%20down%20menu%20nothing%20shows%20up.%20Please%20help.%20I%20have%20tried%20researching%20it%20but%20everything%20is%20about%20running%20a%20macro%20from%20a%20drop%20down%20box%2C%20not%20actually%20changing%20the%20selection%20of%20a%20drop%20down%20box%20from%20the%20macro.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2557936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2558022%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20run%20a%20macro%20that%20selects%20options%20from%20combobox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2558022%22%20slang%3D%22en-US%22%3EWhich%20type%20of%20ComboBox%20it%20is%3F%3C%2FLINGO-BODY%3E
New 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?