loop through values in listbox and search for them in excel sheet

How are the values added to the ListBox? A sample workbook would help

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Dritrantirane,
Welcome to the forum.
Please take a moment to read our rules.

This thread is about userform list boxes. Your question about text formatted cells would be answered quickest if you were to start your own thread.

longhorn,

Given that way of filling the list box, I don't see a need to search for the terms.

Please Login or Register  to view this content.

should do what you want.

Well...I when it finds those values in Sheet1, I have to copy those columns in which the values are and then I have to create a new sheet, and paste in those columns...

(The reason I made a userform is so other's can do this by clicking a few buttons....basically automating the process...)

I've attached an .xls file if you want to take a look at the code...

From the OP it sounds to me like you want all of the columns/listbox items.

Is that the case, or are you looking to choose one item from the list box and get one column of cells.
If that is the case

Please Login or Register  to view this content.

should do it.

Thanks a lot for the help!! I really appreciate it.

Basically when the columns load into the left listbox, the user will be able to choose and move those chosen values to the right hand listbox. So I'm looking to get ALL of the values in the right hand listbox, whether they be 1 or 3 or 7, etc.....and then create a new sheet, and paste in those columns(<< that part of the code I have, by the way)...

Also where should I put that piece of code you gave me?