Hi there,

I have a listbox in a userform that is populated from an array, please see image below;

Untitled.png

I have a second userform with 3 buttons that sets the DataRetrieval to the word "Supplier" (DataRetrieval is Public to string in a module), I'm trying to select the particular elements of the listbox (listbox name = listbox01) to match against another criteria to populate a second listbox (listbox name = listbox02), but I keep getting an error message 13 type mismatch, can anyone help

Stockdata refers to a sheets("Stock_Data").Range("A2:V46")

Code;

Please Login or Register  to view this content.