COMBO BOX or FORM!

[Juanjo]

HI,

I have the following problem, I have a matrix of NxN and inside the
matrix I want to add something like a combobox to give the users the
capability to select the values from a predefined set of variables.
How I can do it is a very easy way? Its possible to do it without
Visual Basic?

Here is an explample of what I want to do...

Fruits State Color
Apple Combo1 Combo2
Banana Combo1 Combo2

Then I define the combos as:

Combo1
Good
Bad

Combo2
Red
Yellow

Many Thanks!!!

 

[Bill Lunney]

Select Data > Validation.

Choose List from the allow options

Set Source to the range of values you want to allow.

This will let the user only enter something in the list. There are some
cases where this won't work but for the purpose of this discussion the
described method may work for you.


--

Regards,


Bill Lunney
www.billlunney.com