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

List box query
 

I have worked it out,

Thanks

Greg B
"Greg B" wrote in message
...
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