getting type mismatch using list listindex

I don't know how this used to work. Your listbox has 1 column, but your formula is referring to the second column. Column indexing for a listbox is 0-based, so column 0 is the first column and column 1 is the second column. The reference to

.List(.ListIndex, 1)

is returning Null. If you are trying to get the item selected as displayed in the listbox, you can omit the column reference.

Please Login or Register  to view this content.

OK, I have to do a little mind reading here. I think what you intended to do is to use the second column of the listbox to store the row number of the selected item where it appears on sheet VendorInfo. But the listbox only has one column, and that info is never stored.

I updated the properties of your listbox to have 2 columns, and made this update to your Search Sub:

Please Login or Register  to view this content.

And it seems to work but it's hard to check because I cannot figure how your tb_* variables are defined.
Then I get a type mismatch error at

Formula:

Please Login or Register  to view this content.

The ListIndex value is 0 and so the array index is 1 but I can't figure out how arr is assigned values so I got stuck here. I did not want to sink more time into diagnosis at this point until you can explain how arr is being used.

Your attachment in post #3 did not work. I am guessing you tried to attach an image. I think there is a bug in picture attachments. Try going into Preview mode before you attach the image.

The fact that arr is declared globally in one place and locally in another place and used for different things make this code very confusing to follow. The only place you are assigning values to the global version is in CommandButton4_Click_old which appears to be obsolete. And so when ListBox1_Click references it, it causes an error. Since you are after the row number here, I will use the row number that was stored in the list in my previous update.

My general sense is that the overall design is more complex than necessary but I'll just focus on getting it to work. Please try this out and let me know if it works the way you want.

Glad to help, thanks for the rep!