Validation list problems
 

Hi all,

I had a question about validation lists which hide previous selections. I
read the torturial on: http://www.contextures.com/xlDataVal03.html. I tried
it and it worked but i would like to add choises to the list which cant
dissappear if previous selected.
For example: a list contains the choises: 1, 2, 3, 4, 5 and X. Where X can
always be choosen and the numbers only if not previous selected. So you can
have something like this: but not this:
1 3
X 2
3 3
2 X
5 1
X 4

Is this possible? I do think so. And f it is possible do you know a site
where this is all explained?

Validation list problems
 

Hi Newbie16,

Check this out, maybe it will help:

1st - On a separate tab that you can hid later put the data that you
want in a column, like this:
A1= 1
X
3
2
5
X

Now on your top Toolbar go "Insert" ~ "Name" ~ "Define"

Define Name Box will open
In the "Names in workbook" let's type "Data" for this purpose. Go to
the bottom of the box to "Refers to:" and select the data you want to
appear in the list box ... will look something like this
"=Sheet2!$A$1:$A$6"

Finally, on the right side of the box click "Add" and then "Okay"


2nd
Go to the tab and cell with you want the list box
Now on your top Toolbar go "Data" ~ "Validation" and "Settings" tab

In the "Allow:" box select "List" then in the "Source:" box type
=Data (if you choose another name when you defined the data then
it will be ="Your Name"

Click okay and your set

Validation list problems
 

Thanks xLBaron but i guess my question was too vague because i think you dont
know my problem.

On http://www.contextures.com/xlDataVal03.html they show you how you can
make a validation list (something like a combo-box) which removes choises
that have been choosen earlier. If you have a list that contains 6 different
names you can make a dropdown list, when youve selected (some) cell(s) doing:
Data|Validation|Allow-List and for 'source' you type something like A1:A6
But if you want multiple cells that have the same validation list, but dont
want to be able to make the same choise twice then this site shows you how
this can be done. Ive read it all and it worked.

There is only one problem. If you have excactly 6 cells with the same
validation list containing 6 names and you have chosen for each cell a name,
you cant undo this. This is because the functions in the example on that site
delete the choises you already have done. So when all choises are used, you
cant click the 'V' sign on the right of a validation-list-cell. What can i do
about that? I thought of making the list one cell larger by adding a lable "
". But that cell should be an unlimited choise unlike the rest of the list.

Check the site for more clarification.

Thanks in Advance

Validation list problems
 

You could turn off the Error Alert for the data validation cells. Then,
when the dropdown arrow stops working, type any entry in a cell.

If you want the dropdown arrow to continue to work, but to show an empty
list, you could create a range named AnyValue, which is a single blank
cell. Then modify the data validation formula:

=IF(COUNTA(NameCheck)=0,AnyValue,NameCheck)

newbie16 wrote:
Thanks xLBaron but i guess my question was too vague because i think you dont
know my problem.

On http://www.contextures.com/xlDataVal03.html they show you how you can
make a validation list (something like a combo-box) which removes choises
that have been choosen earlier. If you have a list that contains 6 different
names you can make a dropdown list, when youve selected (some) cell(s) doing:
Data|Validation|Allow-List and for 'source' you type something like A1:A6
But if you want multiple cells that have the same validation list, but dont
want to be able to make the same choise twice then this site shows you how
this can be done. Ive read it all and it worked.

There is only one problem. If you have excactly 6 cells with the same
validation list containing 6 names and you have chosen for each cell a name,
you cant undo this. This is because the functions in the example on that site
delete the choises you already have done. So when all choises are used, you
cant click the 'V' sign on the right of a validation-list-cell. What can i do
about that? I thought of making the list one cell larger by adding a lable "
". But that cell should be an unlimited choise unlike the rest of the list.

Check the site for more clarification.

Thanks in Advance




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html