Populate a combobox in a userform with a dynamic range.

I have a combobox in a userform, and I would like for the options to be from a dynamic range within my workbook. Generally, I use this code to make it work:

Please Login or Register  to view this content.

This code has worked fine, but I have recently hit a snag. If I am viewing a different worksheet than the range is on, I get an error. This is a problem because I have information on a hidden worksheet that I would like to populate the combobox. Does anyone have any suggestions?

Hi there,

Please Login or Register  to view this content.

Sorry, but I doubt that that code EVER worked, because there are two errors in it - there's a missing A, and one set of quotes is not closed.

I think the correct version should be:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Roy:

Your code worked perfectly, thank you.

Greg:

I did copy my code over incorrectly. Your solution works as well.

Problem resolved.

Hi again,

Thanks for the feedback. You're welcome - glad to have helped.

All the best,

Greg M