VBA Userform match issue

[nbrown6]

Hi all,

This will probably be really simple, but im pulling my hair out trying to understand why this wont work.

I have produced a basic sample of what i have in another bigger project.

I want the code to lookup the value entered in a userform textbox. Iv used the _Exit event to trigger the code which uses the Match funtion to return the row.

For some reason this does not work with the long number (rfid tag id) but if you use 'Test' it works perfectly.

Could someone have a look and point me in the right direction.

[Paul_Hossler]

Textbox returns strings, but you're matching numbers

The double -- just makes it into a number

targetrow = Application.WorksheetFunction.Match(--TextBox5, Sheets("runners").Range("Tag_Number"), 0)

Capture.JPG

[nbrown6]

Cheers Paul,

Knew the answer would be really simple. Thanks for having a look.