Type Mismatch when trying to offset from user selected value

I am trying to display a users information based off of a user ID that they select, and then display corresponding information in text boxes on a form. I can display the user selected ID number but am having trouble using an offset function to display the rest of the information and keep getting a type mismatch error. Any thoughts?

This is my code where txtActID and txtDescription are both text boxes on a form. The txtActID displays the correct value but it is the txtDescription line where I am getting the type mismatch error.

Please Login or Register  to view this content.

Hello cmurda,

You need to check that Application.Match has not returned an error before you proceed in your code.

Assign the return value to a Variant type varaible and check it like this...

Please Login or Register  to view this content.

As is, r3 is only one cell.

Please Login or Register  to view this content.

Hello

You can check the Ret value and see which error you have encountered. Just remove the IsError() from around Ret.

Place your cursor on the code line and press F9. This will place a breakpoint in your code. The code will stop at this line and you an see the value of Ret.

Please Login or Register  to view this content.