Case Statements

[Todd Huttenstine]

I have combobox1. There can be 52 different possible
values in the combobox. How do I set up a case statement
that will say... If combobox1.value = 1 then a if 2 then
b if 3 then c and so on....


Thank you

 

[Jake Marx]

Hi Todd,

Select Case ComboBox1.Text
Case "1"
'/ do a
Case "2"
'/ do b
Case Else
'/ didn't match
End Select

That is, unless you can figure out a way to make your process simpler (ie,
less than 52 cases).

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Frank Kabel]

Hi Todd
have a look at the VBA help

try something like
'...
Select Case combobox1.value
case 1
'do something for 1
case 2
'do something for 2
'...
case Else
'don't know what to do
end select
'...