Manually enter values into Excel Combobox

[skipjakk]

Just want to make a simple combobox with a few pulldowns, which will never change, is there anyway to just manually type in the values somewhere in the combobox properties? I'm trying to avoid VBA, and setting up a list somehwere else in Excel....

Thnks.

 

[Fenrirshowl]

You could use validation (under the data menu) rather than a combobox - with this you can type in the values you want to be listed, or link it to a part of the worksheet.

Fen

 

[SkipVought]

"I'm trying to avoid ... setting up a list somehwere else in Excel...."


Why would you avoid the SIMPLEST and EASIEST way to modify a Combobox list?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[skipjakk]

People tend to overwrite the values, I would rather just type in the values within the combobox properties, that way they don't get changed inadvertenly....

 

[SkipVought]

"People tend to overwrite the values"

Not if you put them on a hidden sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}