View Single Post
 
Old 03-28-2019, 08:04 AM
VitorH VitorH is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2019
Posts: 1
VitorH is on a distinguished road
Default 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
Reply With Quote