View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newbie16 newbie16 is offline
external usenet poster
 
Posts: 2
Default 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?