Excel Ribbon dropdown

I have customized a new tab on the ribbon, incorporating Ron de Bruin's dropdown XML and Vb code and it does work - I can select repeatedly from the dropdown and it takes the user choice and puts in cell B10. The info in B10 is used in a lookup with results in L10. The info in cell L10 is used by another macro that initiates a user form.
Here is the problem - I can continue selecting from the dropdown with no problems UNTIL I run the macro that launches the user form that uses the info in L10. Once I have run that macro/userform I get an error in selecting from the dropdown
Here is the dropdown Vb

Please Login or Register  to view this content.

Here is the "other" macro and userform (I have used ***** in this post to separate)

Please Login or Register  to view this content.

By no stretch of the imagination am I good at Vb but have got this far
So the error I get is with the change handler for the dropdown
Error 91, Object Variable or With Block Variable not set
I have struggled for a couple of days (and nights) to solve this but am at a loss at to why the dropdown will continue to work after running every other macro but the one that uses related information. Any help would be GREATLY appreciated!
thanks much
Vonda
PS this is a very large file and doubt I can email or attach

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Does your userform use the END command at all. Maybe you are clearing all the variables by accident.

I think you will have to attempt to post a cut down version of your workbook.
I'm assuming it's large due to the data rather than the vba code and ribbonx.

Both CommandButton Click events have an END statement in them which serves no purpose that I can see, so as Andy said, remove those and you should be OK.

Thanks RS, I didn't see those End's in the code.

Use:

Please Login or Register  to view this content.

You definitely have no End statements left? And the error is occurring in the same place? (did you restart the workbook?)