Populating Combobox with simple Name

[ImranBhatti]

Hi,

I have created 2 Names in Excel Name Manager like this

Please Login or Register  to view this content.

What I want is to populate 2 combobox from the same Names.
Your help would be greatly appreciated.

Best Regards
Imran Bhatti

[ImranBhatti]

Currently using this workaround but is there a way to directly populate lilke ComboBox.List = Abr

Please Login or Register  to view this content.

[rorya]

You could put an array into the name:

Please Login or Register  to view this content.

then assign it like this:

Please Login or Register  to view this content.

though I'm not sure I see how that's a real improvement.

[ImranBhatti]

That did the trick Rory.

Much appreciated indeed

[ImranBhatti]

Sorry for marking the thread "Unsolved" again.

at first I actually assign the [Abr] to an array which was successful but while trying to directly assign it to combobox's .list it says

"Could not the list property.invalid property index"

[rorya]

That tends to mean that your variable is not actually an array.

[ImranBhatti]

"Could not the list property.invalid property index"

occures when I directly assign the name to combobox like this

ComboBox.List = [Abr]

But when I do this

AnArray = [Abr]

it does contain values of "Abr" if I add a watch on "AnArray"

[bakerman2]

This seems to work for me (if I understand correctly).

Please Login or Register  to view this content.

[bakerman2]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.