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;
Bookmarks