How do you use a drop down list value to trigger a macro

Hi Ryan

Thanks for getting in touch. I assume you mean a drop-down list derived from Data Validation. You can't cause a macro in the standard way, you will need to trigger a Worksheet_SelectionChange event.

This can be quite an involved procedure that should be handled with care, so if there is an alternative I would recommend that. For example design a VBA userform with appropriate macros, or trigger a standard function instead. The standard Excel controls do not work well with macros without a bit of effort.

If you provide a bit more detail on what you want it to achieve, we may be able to suggest an alternative.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector