G
Greg B
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
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