vba: find command, finding exact values

[icylemontea]

I have tried using the vlookup function in VBA, but that has failed to work.
I am now using the following code instead:

Please Login or Register  to view this content.

This returns into textbox2 the value found in the second column of the spreadsheet which corresponds to the value in textbox10. My problem is that the values I have in the 1st column (the column containing the lookup value) are numbers and the code I am using seems to be finding the value which corresponds to the first number which has the number entered in textbox10 nested in it rather than the exact number itself.
For example, the list of numbers I have in column 1 are
135
35
100
If the value in textbox10 is 35, the value I get in textbox2 corresponds to the first number in the list containing 35, that is 135, rather than the exact number 35 itself. How can I solve this?

Thanks!

[JBeaucaire]

1) Be sure to edit your post above and put CODE tags around the code, as per the Forum Rules.

2) Also, as per forum rules, you should change the title so that it depicts the topic, not something that doesn't work so isn't really part of the topic.

3) You should always include the parameters LookIn: and LookAt: in your .Find commands. .Find is one of those quirky functions that will use the last LookIn/LookAt parameters from the last time it was used (manually or VBA) and use that setting if you leave it out. Very bad.

Please Login or Register  to view this content.

[icylemontea]

Thank you!

[Leith Ross]

Hello ,

Please use code tags around your code. It makes the code easier to see and copy. Here is an example of how to use VLOOKUP in VBA. It functions a little differently than the worksheet version. In the VBA version you must specify which column of the range you want to search as the VBA version will examine by using the Columns property.

Please Login or Register  to view this content.

[icylemontea]

Many Thanks Leith.