Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box query
Hi all,
I am having a problem with a Listbox. I have a list box which retrieves the following in the columns reg# Fullname Sex Fname Lname I populate the list by using an autofilter using a textbox, The problem I am having the autofilter is done by using wither the first name or last name. which is columns 4 or 5. But I need the Reg # which is column 1. here is the simple code I am using and how can this be changed to suit Private Sub ListBox1_Click() Sheet3.Range("A10").Value = ListBox1.Value End Sub Thanks in advance Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List box query | Excel Programming | |||
Drop down list query | Excel Programming | |||
List Box Input to query | Excel Discussion (Misc queries) | |||
List Query | Excel Worksheet Functions | |||
Dependent List Query | Excel Worksheet Functions |