Prev: A single Page print for key items
Next: text combined with values
From: rwbaker on 28 May 2010 08:52
excel 2003
I have several cells that I have some custom data validation configured
I also want to have a in-cell drop down list for these cells

Can some please tell me how I can do this

I go to the data - validation and select list but it seems to take away the
custom data valadation I have
From: IanC on 28 May 2010 09:52
You can't have custom validation AND list validation. As you've discovered,
they are mutually exclusive. If you have list validation, the cell will only
accept entries on that list.

Create the list on your worksheet, then point to it by entering your range
of cells preceded by equals in the source field (eg =F7:F9).

I'm using Excel 2000 so the next bit may differ:

If your list is on another sheet or in another workbook, you will have to
create a named range and point to that in the source field instead (eg
=NamedRange).

Hope this helps.

--
Ian
--

"rwbaker" <rwbaker(a)discussions.microsoft.com> wrote in message
news:F8CC6494-6AA5-402B-AE60-7F0BDFCAE620(a)microsoft.com...
> excel 2003
> I have several cells that I have some custom data validation configured
> I also want to have a in-cell drop down list for these cells
>
> Can some please tell me how I can do this
>
> I go to the data - validation and select list but it seems to take away
> the
> custom data valadation I have
>


From: Gord Dibben on 28 May 2010 10:13
One or the other, not both.

If the items in the dropdown list are in conflict with the current DV
restrictions you are out of luck.

Can you in some way combine the two?

Post some examples of existing rules and items to be "listed"


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 05:52:01 -0700, rwbaker
<rwbaker(a)discussions.microsoft.com> wrote:

>excel 2003
>I have several cells that I have some custom data validation configured
>I also want to have a in-cell drop down list for these cells
>
>Can some please tell me how I can do this
>
>I go to the data - validation and select list but it seems to take away the
>custom data valadation I have

 | 
Pages: 1
Prev: A single Page print for key items
Next: text combined with values