Search button in userform

[Ray316]

Hi, this is the first time I create a userform. So bare with me plz.

I have a command button called "search".
What I am trying to make it do: when the user types a word in textbox1 and then he clicks the search button. It will search for that word in column A to BA.
If he doesn’t find the searched word --> a message will appear in textboxe2 "no results found".
If there is a result --> it will copy the cells in texteboxe2. (The word can be found in multiple cells) EX: A50, A52, A70, D20, D30, D60, V45, V53 and V90

The result should look like this:

A1<-- the first cell of the column must appear before the result in that column.
A50
A52
A70

D1
D20
D30
D60

V1
V45
V53
V90

So far, I got this code and I am stuck:

Please Login or Register  to view this content.

Thank you for the big help.

[royUK]

Do you mean Column BA or B, your code seems to use Columns A to B?

[royUK]

Not sure if this is what you want.

Use a ListBox instead of the TextBox

[Ray316]

Hi Roy,
The range is from columns A to BA.

Thank you for the help. In general, is exactly what I want.

I tried what you gaved me on my tester, and there is few pointer.
First, the clear button doesn't work anymore on the result box. Is that because you change it to a list box?

Second, when I get the results, it start with a weird symbol (Ex: $P$2)
I don`t know why it does that.

basicly, before every correct result (in listbox), I want him to give the value found in the first cell of the same column where the result was found.
I hope that is clearer.

P.s. I am sorry for the confusion, I am trying to be as précise as I can be.

[royUK]

I've made some amendments

Please Login or Register  to view this content.

I had set the code to list the address of the cell containing the word, $P$2
The clear code simply needed to include the ListBox

[Ray316]

Hey Roy,
I tested and it works!!!!.
Thank you for the help. I really appreciate it.