How not to use ComboBox change event?

[Waimea]

Hi,

I want to use a select case for the value of a combobox but I don't want to use the combobox change event?

Ex. If combobox1.ListIndex = 1 I want a macro to run, and if combobox1.listindex = 2 I want another macro to run?

 

[My Aswer Is This]

Well sorry I cannot help. I really would not think you need 320 scripts or 320 case statements.

I'm not sure I can help on this particular question without knowing fully what your wanting.

For some reason you believe you need dependent comboboxes which may be true but then still need numerous case statements.

It would be nice if you were to give a exact example of maybe three case statements and what each one would do.

For example if Country equals Germany and City equals Frankfurt then do this.

And country being one named range and Frankfurt being another named range.

Assuming each city and country had named ranges.

But then maybe someone else here on the forum can see what you want and be able to help here. I admit others here sometimes can understand needs easier then me.

I assume your still not at a Computer. Maybe your on Holiday vacation. I wonder if the wife is saying get off that Smart phone talking about Excel and Talk more with my Mom and Dad.