User form Display issues

I have a user form which displays a list of options based on a named Range.

in 2013 version of excel it works fine, however in the 2016 version it returns a Runtime error 91 object variable or With block variable not set.

debug take me to my sub where it highlights userform.show vbModeless

any help will be grateful

regards

Dave

Originally Posted by mikerickson

What happens when you step through the code. Frequently that line is highlighted when the actual error is in the userform's code.

Hi Mikerickson

Thanks for the reply.

Stepping through works through the code with no problem, at the end when it suppose to display it then throws up the run time error

I have also just checked that If I block out the code contained in the userform it displays with out a problem just no options

I am a bit confused 🤔🤔🤔

I have since discovered that the problem appears to be in the bottom section of the code

It's not clear without seeing the file and all the code, where you're setting what "Xlist" actually is.
You refer to it in the code but haven't actually set it within the code you've posted.

BSB

Glad I could be of assistance

BSB

Originally Posted by BadlySpelledBuoy

Glad I could be of assistance

BSB

All works now,

Well it did on my computer now I have loaded it on my works laptop which 80% of staff have and it appears that one of the VBA reference tools is missing (microsoft windows common controls 6.0 (sp6)) so not sure what I’m going to do now