WorksheetFunction match - Userform

[Villalobos]

Hello,

I would like to ask your help regarding WorksheetFunction.Match.

In the sample file there is a userform and I would like to fulfill the textboxes with the related informations which are linked with the selected "Account assignment number" <- this can be seen in ListBox1 (please type 9 in the search box).

My problem is that if the "Account assignment number" is contain only numbers then the WorksheetFunction.Match property is not working (but if the "Account assignment number" has letter -like: P- somewhere in the number then there is no problem).

I attached the sample file.

Thank you for your reply!

[AlphaFrog]

This tests if the selected listbox item is numeric and converts the text to a value.

Please Login or Register  to view this content.

[Villalobos]

Hi AlphaFrog,

Thank you for the prompt reply, you were very helpful with me!