Yes Bob, my apology.. You are Right -- I am not Snowfire as you assumed - I
just try to learn by looking over the shoulder of others that do not know...
Actually, My first "impression" was to put the one-linner inside of the On
Focus event, then second inside the Worksheet_Activate Code.. But both
without success.. Therein the Q...
Can you OPEN MY EYES?
Jim

"Bob Phillips" wrote:

Jim,

You are not Snowfire are you?

I was assuming that the combobox was on a userform, in which case it would
be in the userform activate event.

If it was a combobox on a worksheet, it will need a bit of modification.
Then I guess you would execute it in the worksheet activate event.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jim May" wrote in message
...
Bob,
Still not familiar enough to know where to put your suggested one-line of
code.
If the ComboBox1 is, of course Sheet1 then no doubt in the sheet1 code
window..
But inside what event handler?
Thanks,
Jim

"Bob Phillips" wrote:

Me.ComboBox1.List =
Application.Evaluate(Names("defined_name").RefersT o)


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Snowfire" wrote in message
ups.com...
I want to store an array of Emailnames in a Define Name "range" so
they are semi hidden.
How can I add to an existing list and how can I retrieve name from
this stored list to a Combo. I have worked out how to create an
initial list and load this into a combo but lost on manipulating it.