What is the function you are aiming for? Depending on that you may b
going about this the wrong way... Just a thought...

In the meantime, like this

Select Case ComboBox1.Value
Case 1
{DoStuff}
...
Case 52
{doStuff}
End Selec

--
Message posted from http://www.ExcelForum.com