Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Record Box | Excel Discussion (Misc queries) | |||
Find record | Excel Worksheet Functions | |||
Find Record | Excel Discussion (Misc queries) | |||
Find the Record | Excel Programming | |||
Finding a record using multiple combo boxes as my search criteria | Excel Discussion (Misc queries) |