This is a similar problem which I have posted before in this link,
but in a different condition.
I have a UserForm Listbox which has two columns,
one for the name of the customer and one for purchased total price.
The ListBox is populated from a "temporer" pivot table, so the code is like this :
What I want now is to searh the ListNama item by adding a TextBox.
The code for the TextBox that I got from AlphaFrog before (in the other thread) is:
I've tried to change the blue code to like this:
But it doesn't work.
How do I modified the TextBox1 code above as my situation now :
1. There is no named range
2. the ListBox has two columns
Any kind of respond would be greatly appreciated.
Thank you in advanced.
Addition:
Just now I'm trying to make the code for the TextBox something like this :
(The bold codes is the additional ones)
It doesn't work with a purple lines.
If I delete the purple line, it works but now the TextBox only has one column, the name only.
Bookmarks