Type mismatch when using Application.VLookup

[oteixeira]

Hello to all,
On the following piece of code I?m trying to store the value of ComboBox1, on UserForm frmForm on a cell.

Please Login or Register  to view this content.

I'm getting the Run-time error '13'
Type mismatch
On line:

Please Login or Register  to view this content.

Can someone please give me a hand on solving this? I have searched but found no solution. Also I have another piece of code using the same approach and it works fine?
Many thanks,
Octavio

[TMS]

HTML codes don't work. Use the # icon. We can't see your code.

[oteixeira]

Hello,

I edited the post. I think it is visible now...

[oteixeira]

Answering myself,
I was looking for the entire content of ComboBox1 value when I should look only for from the second character on... that's why variable t was null...

Greeting,
Octavio

[TMS]

Thanks for sharing your solution.

Tough one for us to work out from just the code snippet



Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[oteixeira]

TMS, thank You for the advice. I'm aware of that and I allways thank and add reputation to the wonderfull people giving help here.

Cheers,
Octavio