Hi Dan,
Thanks for the response. I appreciate it.

Actually, I was hoping to have the list be a global list for use in ALL of
my files-- which makes placing it in a single file unusable. We've got over
800 files. Which would mean a single combobox in all of the files, on the one
worksheet.

I'm thinking more a macro that would allow the dropdown to call back to.

Next, you said ActiveX combo box. Is that what I'd need to use for the
worksheets?

Again, thank you.
"dan dungan" wrote:

Hi Steve,

Is this what you seek?

In a workbook on sheet1, i placed an active x combobox from the
control toolbox over cell a3.

On Sheet2 in cells a1:a3, I put a list of names

then back on sheet1, I populated cells a4:a17 with names.

and in cell c4, I entered this formula: =IF(A5=$A$4,"B","C") and
copied down to cell c18.

Dan
.