Userform listbox multicolumn extract values into worksheet

[Monty]

Hello n Goodmorning experts.....Am working with userforms in excel.

I have listbox with multicolumn which is 2 and there is a textbox above listbox to search a text to filter values in listbox....later in filtered values by selecting any items In listbox..those should appear in excel sheet 8n a1, a2..etc..hope my query is clear..quick response is really appreciated. ..Thanks for your help. ...

Sorry could not attatch test file..

MONTY

 

[Deepak]

You might looking something like this.

Private Sub ListBox1_Click()
Sheet1.Range("A1").Value = Me.ListBox1.Value
Sheet1.Range("A2").Value = Me.ListBox1.Column(2)
End Sub

or share the sample wb so that same could get address in a better way.

 

[Monty]

Hello Deepak...Thanks for quick response...I will get back to u with sample wb as suggested.