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
'...



--
Regards
Frank Kabel
Frankfurt, Germany


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