Search function in VBA with conditions

[Ruandi]

I am using a input box and a find function to find the first number in Column A which starts with the 3 digit number that the user types into the input box. This, however, creates errors by the 100th row or so, when that 3 digit number appears in other data previously in the sheet. So I need a SEARCH function that will search for the 3 digit number typed in by the user, and only look in the first 3 digits of column A to find this. I hope this makes sense, and I hope that someone can help?

[tigeravatar]

Ruandi,

Welcome to the forum!
Give this a try:

Please Login or Register  to view this content.

[Ruandi]

Thanx it works perfectly for the biggest part, except that I have some cases where the machine number starts with a zero. So I will type in 012 and then it will return "No matches for [12]". How do I adjust this code so that it doesn't eliminate the zero at the start of the 3 digits? I've tried changing define dFind as a string, but it just gives the same problem. I've also tried putting dFind in inverted commas in the find functions, but it also doesn't work. Any solutions?

[Ruandi]

I got the problem of the zero solved by playing around with the code. I my solution, with comments to explain the changes, was:

Please Login or Register  to view this content.

Thank you very much for the help! I'm so glad I registered on this Forum!

[tigeravatar]

You're very welcome, and I'm glad you got it sorted