Type mismatch with Excel userform listbox

  • Hi, again!
    I have managed to put together excel userform for looking up data in excel!
    I have created a listbox (two of them) which are filled up in two columns when the criteria meets!
    But when I`m testing this thing the error mismatch pops up ( Could not set the List property. Type mismatch. Run-time error `-2147352571 (80020005)` , what does my code is missing??!?!


    Here is the code:



    &


    MODERATOR NOTE: please remember to use code tags in future as per forum rules.

  • Re: Type mismatch with Excel userform listbox


    What line do you get an error on? (What code line is highlighted when this occurs?)

    Matt Mickle
    Using Excel 2010,2013 & 2016

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!