asked on run excel vb script based on combobox
Guys,
I need some help. I have attached an excel sheet which has a combobox in sheet "MAIN" what I want it to do is look at a specific folder and list all the subfolders so that I can choose. Then when you press the IMPORT button I want the vb code behind the IMPORT button to use what I have chosen in the combobox to execute the script.
Can anyone help
Book1.xlsm
I need some help. I have attached an excel sheet which has a combobox in sheet "MAIN" what I want it to do is look at a specific folder and list all the subfolders so that I can choose. Then when you press the IMPORT button I want the vb code behind the IMPORT button to use what I have chosen in the combobox to execute the script.
Can anyone help
Book1.xlsm
Microsoft ExcelVB Script
Last Comment
DarrenJackson
ASKER
HI kyodai thanks for helping.
The example you have given wont give me the ability for my combobox to look up folders within a subfolder.
I think you have misread my question
The example you have given wont give me the ability for my combobox to look up folders within a subfolder.
I think you have misread my question
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Where would I place this within my attached excel file so that when I press on the drop down box within my combobox I get the folders within C:\ ?
Regards
Regards
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Rory this is perfect.
Thankyou for this.
Thankyou for this.
if Combo1.ListIndex = 0 then
'execute first script
RunScriptOne
elseif Combo1.ListIndex = 1 then
'execute second script
RunScriptTwo
...