find-record combo box
 

I developed a user form to search data in a list of records. A combo box on
the form is linked to the list. Now what I am wandering is if it is possible
to set up the combo box to select the active cell in the list when an item in
the combo box is selected.

Thanks,
Iurie T

find-record combo box
 

Private Sub Combobox1_Click()
With Worksheets("Sheet1")
.Activate
.Range("A1:A10")(Userform1.Combobox1.ListIndex+1). Select
End With
End sub

where A1:A10 represents the location of the list linked to the listbox

--
Regards,
Tom Ogilvy


"Iurie" wrote:

I developed a user form to search data in a list of records. A combo box on
the form is linked to the list. Now what I am wandering is if it is possible
to set up the combo box to select the active cell in the list when an item in
the combo box is selected.

Thanks,
Iurie T