biker9
asked on
Multiple criteria from two data validation lists sets trigger for macro
Hello Experts,
I need a bit of code that will select a macro based upon user selection from two data validation lists, each list contains 4 choices. The macro is triggered upon a button click.
Thanks,
biker9 Criteria-sets-macro.xlsm
I need a bit of code that will select a macro based upon user selection from two data validation lists, each list contains 4 choices. The macro is triggered upon a button click.
Thanks,
biker9 Criteria-sets-macro.xlsm
ASKER
Thomas,
when I run the code, I get an error msg "400" ?
tx,
Ray
when I run the code, I get an error msg "400" ?
tx,
Ray
Are you running it from personal.xls or the workbook where the button is?
ASKER
I now get a run time error 1004 with the file you sent.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect,
Thanks Thomas,
(ps. sorry..i thought i had closed this off a couple days ago)
Thanks Thomas,
(ps. sorry..i thought i had closed this off a couple days ago)
No problem. Glad to help.
Thomas
Thomas
Here is my update
Open in new window
Thomas