Hi,

I have this scenario where I need to run macros or methods or routines when a user selects multiple choices from a dropbox (does VBA suppoort multiple selections?) and run them accordinly:

Private Sub ComboBoxPickLetters_DropButtonClick()
comboboxPickLangs.List = Array(a, b, c, d, e)
' Then user selects options b, c and e from the dropbox
' How can go about running those options b, c and e selected by user?
' Is Case statement a solution?
Case a
run a
Case b
run b


Case c
run c
Case d
run d
Case e
run e

' Or do I need a loop in order to run b c e choices? Thanks

What sort of 'drop box'?
Active X? Userform Combo Box? Content Control? Form Field?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com