Getting item from list box

[Svmaxcel]

I created listbox with 2 columns
Now I want that when I click an item in listbox and click commandbutton1 how can I get the value in Excel Cell.
Note I only need value of listbox, column 1 selected item

 

[AlanSidman]

Show us a sample workbook with before and after scenario.

 

[Svmaxcel]

Ataching Sample file for reference

When i type in text box, the matching Emp Name is searched and it appears in Listbox

I have below issue
1) it Should search in Emp Name and Manager also(if user type XYZ then all Emp under Manager XYZ will show in List box.

2) list box has heading columns, but they are blank(it should have defaults columns based on table.

3) When user clicks on an item in List box and clicks on select, the Emp Name and Manager Name should be F3 and F4.

4) in case the code does not work, user can reset it, so how can that be done

please assist

 

[Belleke]

Something like this?

 

[Svmaxcel]

Th

Something like this?

Thanks for response.

Here are the issues.

once I search something and tgen backspace it to search for something else, it doesnt work.
So had to reset the form to search again.
No headings in liSt box.
its only searches for Emp name and not manager.

 

[Belleke]

Solved
Version 2

 

[Svmaxcel]

this was great buddy
however the heading is missing
I mean Emp Name/Manager
also can i use one search box to search for Emp Name/Manager.

I mean in search bar, if i type ABC, it will list all Employee and Manager name

I also think that the Reset button is no more required