Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-28-2019, 08:04 AM
VitorH VitorH is offline Execute a Sub OR routine or macro based on multiple user choices from a dropbox Windows 10 Execute a Sub OR routine or macro based on multiple user choices from a dropbox Office 2016
Novice
Execute a Sub OR routine or macro based on multiple user choices from a dropbox
 
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
 

Tags
combobox, selections, user



Similar Threads
Thread Thread Starter Forum Replies Last Post
Execute a Sub OR routine or macro based on multiple user choices from a dropbox Need macro for automatic point value insertion based on the number of answer choices selected ganesang Word VBA 29 08-12-2018 09:38 PM
Need macro for automatic point value insertion based on the number of answer choices selected ganesang Word 1 07-31-2018 06:07 AM
Execute a Sub OR routine or macro based on multiple user choices from a dropbox Macro to replace text and track changes based on user-defined rules Thefirstfish` Word VBA 13 01-09-2016 07:14 AM
Populate a table based on choices from drop down menu Xaand Word VBA 0 02-25-2014 11:08 AM
Macro or routine required evanhughes Outlook 0 11-18-2011 02:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft