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]


Todd Huttenstine wrote:
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