Not missing a paren, missing a double quote.

--
Regards,
Tom Ogilvy

"nrage21 " wrote in message
...
Sorry Tom! (stupid me!!)

listfillrange from the properties box :)

I followed your instructions and when I get off design mode and click
on the combobox I get a syntax error.

Private Sub Combobox1_Click()
res = Application.Match(ComboBox1.Value, _
Worksheets("Sheet1").Range("B1:B17"), 0)
msgbox Worksheets("Sheet1").Range("A1:A17)(res).Value
End Sub

any ideas???

- Larry -
VBA Amateur


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