Execute a Sub OR routine or macro based on multiple user choices from a dropbox
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
|