Grgeor,

From previous posts I will assume an activeX control. You need to identify a
key column, lets say B. Set the ListFillrange property for the cells in
column B, and then use the .ListIndex property on a combobox click event to
identify which record (it will equate to the row - 1).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gregork" wrote in message
...
Hi,
I have inserted a combobox on a worksheet that I want to act as a record
selector for showing one record from my list of 500+ entries. Trouble is I
have no idea how to write a code to achieve this. Any help or sample odes
would be appreciated.

Regards
gregork