Validation List in Excel 2000 2

[Ben1637]

Hi Everybody,

I created a combo box in Excel by using the Validation function (Data --> Validation --> List). It's a simple drop-down menu with 'Yes' and 'No' as the two choices. However, I would like to include a blank option so if a person accidently chooses Yes, they could change their entry to blank (or no selection). As it stands now, the user would have to select the cell and hit Delete on their keyboard to remove any values in the cell. Is there a way to include a third option in the list that doesn't contain any text?

Many thanks, in adavance!!!

 

[kpetursson]

Somewhere else in the work book (can be on a different sheet) take three cells, and put in them:
Yes
No
'
then highlight tham and name the range
YesNo
then where you were previously had you list defined in the validation dialog box as Yes,No replace with =YesNo

Is that the result your looking for?

Kevin Petursson

 

[Ben1637]

That's great - thank you, Kevin!!

 

[Greycon]

kpetursson,

How would you go about naming a range YesNo?

I can do it via macro, but what if you are not running one.

Is this ability in XP?

Very Interested in this.

Thanks,

Greycon

 

[kpetursson]

Greycon

Highlight (select) the range you want to name.
In the upper right side on the window you should see a pulldown box. When you have only one cell selected this box contains the address of that cell (ie A1). When you are selecting multiple cells (mouse still down) it contains the #R x #C (ie 5R x 3C), and when you've selected multiple cells it contatins the address of the current cell in the range.

Anyway... To give a name to the selected range, click in this box and type in the name.

The name must begin with a letter, cannot contain any spaces, and must be less then 254 Characters (the last one is technically true, but if you name a cell or range and that name is 253 characters long I think you've got other problems)

You can also name a range through the menu "Insert"->"Name"->"Define"

Using the menu also allows you to delete the name for a range.

You can name the same range multiple times with different names with out an error.

You can jump to a named range by selecting it from the pulldown box as described above.

Want to know anything else?

Kevin Petursson

 

[Greycon]

Kevin,

Thank you. My mind is allready spinning out ways to use this.

Greycon