View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Learning Excel Learning Excel is offline
external usenet poster
 
Posts: 98
Default DV message linked

it is possible to have the data validation message(yellow square) linked to
have a message from another cell ( let's say A1) ? and changing as A1 changes.
In other words, DV is in B1 to B40 ( no dropdown, just with message), A1 says
"adjusted". Could a formula or... do this :
If B1,B2,or B40 is selected they will show in the DV message " adjusted" or
any other that A1 has ? Weird, ah?
Thanks for the answer, even if don't like it.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.