Macro for each option within a combo box activex?

[clogistics]

Is their any way to create a macro, individually, for each option inside of the combo box activex? I understand that you can create a macro for the combo box itself, that contains all the list option, within that combo box. I want to be able to create a macro, individually, for each option in the combo box.

[Andy Pope]

Do you mean execute different macros based on selection of an item in the combo box?

If so you can use code in the select event to determine what item was selected and then execute appropriate code.

[clogistics]

Do you mean execute different macros based on selection of an item in the combo box?

If so you can use code in the select event to determine what item was selected and then execute appropriate code.

Yes, that's what i'm referring to. I've been playing around with codes in the VBA coding area, but i'm not really understanding how to connect the macro, I've created, to the specific selection? I know it's something i'm not understanding with the coding. I've tried "Select Case"... then "Case"... etc.,

[Andy Pope]

something like

Please Login or Register  to view this content.

[clogistics]

something like

Please Login or Register  to view this content.

Yes, that's in resemblance to what i'm trying to accomplish. For example, this is a random macro i did just to run a test.

Please Login or Register  to view this content.

[Andy Pope]

but you are using the Listindex property, which is a value 0 to n-1 (where n is the number of items in list).
And comparing that to text value such as "Fees" so it will never execute and of the cases.

Change to .Value rather than .ListIndex and it will work if text matches exactly