Type mismatch with Excel userform listbox

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!