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?

 

[Fluff]

You could use the Click event

 

[Waimea]

Hi Fluff,

thank you for your reply!

Could I use a select case in another macro based of the value of combobox1.listindex?

 

[Fluff]

yes

 

[Waimea]

I have one activex combobox1 with 22 options and I have one dependent activex combobox2 with 1 to 59 options for a total of 320 options.

I want to run a macro on the selected option in combobox2. However I don't want to create 320 select case statements.

How can I use select case without creating 320 select cases?

 

[My Aswer Is This]

Give us a example of what you will be loading into these comboboxes.
Where do these values come from?

 

[Waimea]

Hi My Aswer Is This,

in the first combobox I have countries, Sweden, Norway etc. In the second combobox I have city names, Stockholm, Oslo, etc.

I am looking at nested select cases with one select case for combobox1 and then nested select cases for city names.

 

[My Aswer Is This]

Where on your sheet do you have these names.
They have to be loaded into the combobox from some place

 

[Waimea]

Hi My Aswer IS This,

I don't have 320 scripts, I have a total of 320 cities in 22 countries.

Select Case ComboBox1.ListIndex

Case 0
   
    Select Case ComboBox2.ListIndex

    Case 0
    call a function with some variables

    Case 1 
    call the same function with different parameters

    End select
End select

 

[Waimea]

The countries and the cities are in named ranges on a worksheet.