Multicolumn Listbox

[Jaye7]

I would like a script that would find all values in column A based on the value typed in textbox1 and then would put the cell value in column 1 of listbox1 and the cell address in column 2 of listbox1.

Can someone please help.

 

[Jaye7]

Xenou, last request.

Can you please provide a script so that when I double click on the value it goes to that cell.

Thanks

 

[xenou]

maybe something like this:

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Me.Hide
Application.Goto Range(Replace(Me.ListBox1.List(Me.ListBox1.ListIndex, 1), "[" & ThisWorkbook.Name & "]", ""))
End Sub

 

[Jaye7]

Brilliant, thanks Xenou, I will leave you alone now.

 

[hhh]

Hi,

how about any code link to userform instead on sheet.Thanks

 

[xenou]

Not sure what you mean by link but to get to a control on a userform you can just use set focus:

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.SetFocus
End Sub

If that's not what you need, I'd recommend you open a new thread as this one's really on a different subject.

ξ