Run Code based on Combo Box value

I have a Combo box and I want to run specific vba codes if the combo box text is different things.

For instance I have 3 funds -

FUND 1
FUND 2
FUND 3

each fund has its own vba code that needs to run

FUND 1 CODE
FUND 2 CODE
FUND 3 CODE

Upon hitting the run button on my form - if "FUND 1" is in the combo box, the macro will run "FUND 1 CODE"

I keep getting errors no matter what I try.

Any help would be greatly appreciated!

Thanks

Is it a "form control" or an "active x" control? Is it on a user form or on a worksheet?

Perhaps attaching a sample workbook showing what you're working with and what you've already tried would be useful.

BSB

I am sorry, I am not sure what you mean.

This is an access database so there is a form that opens that has combo box for user to select. The combo box comes from a table.

Was trying something like:

Please Login or Register  to view this content.

Apologies, I didn't see the Access bit. Brain is in Excel mode today...

Perhaps this would work for you? You'll need to adjust control names etc.

Please Login or Register  to view this content.

BSB

Thank you for your response. I am not sure why, but when I change to "Combo9" which is what my combo box is, nothing happens. No error, but no message box either.

Any thoughts on that?

Did you change it to Combo9 in both places?

Please Login or Register  to view this content.

BSB

Yes I did change to Combo9 in both places

In the properties window for the combobox, under "Event" have you linked the first sub to the Change event?

BSB

Ahhh! Thank you very much! Works now! Appreciate the help!

Glad I could help

BSB