A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

data - validation - list question



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 01:52 PM posted to microsoft.public.excel.misc
rwbaker
external usenet poster
 
Posts: 3
Default data - validation - list question

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
  #2  
Old May 28th, 2010, 02:52 PM posted to microsoft.public.excel.misc
IanC
external usenet poster
 
Posts: 69
Default data - validation - list question

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" wrote in message
...
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



  #3  
Old May 28th, 2010, 03:13 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default data - validation - list question

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
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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.