How to find a number or text in the selected range

[olio39]

Hello

How do you look for a wanted number or text in the selected range.
The range is selected with Range("A10:C1000).Select

How could I check if the number (which will be inputed through the Userform)
is in the selected range, and further: how could I know in which Cell is it?

Thanks for each advise and have a nice day.

[davesexcel]

How could I check if the number (which will be inputed through the Userform)
is in the selected range, and further: how could I know in which Cell is it

Hi,
Why do you need the address of the cell, what is the true function of the UserForm?

[olio39]

Thanks for checking this.

Through the Userform I put only the number, which one will have to be find in the range in the List. Actually it is not importnat.

Important is folowing: the VBA select the range and inside this range I would like to check if the number (for exa,ple 67000) is in this range.
Additioanly I would like to jump to the cell, where this number is and therefore I would need to know which this cell is.

[davesexcel]

Thanks for checking this.

Through the Userform I put only the number, which one will have to be find in the range in the List. Actually it is not importnat.

Important is folowing: the VBA select the range and inside this range I would like to check if the number (for exa,ple 67000) is in this range.
Additioanly I would like to jump to the cell, where this number is and therefore I would need to know which this cell is.

Cool,
Here's a code from Ron de Bruin

Please Login or Register  to view this content.

This will select the first cell in column A with the InputBox value.


Maybe you can get an idea from it

[olio39]

Maybe you can get an idea from it[/QUOTE]


Thanks a lot. I am sure this code will help me.