Thread
:
Can I do two validations on a cell?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
external usenet poster
Posts: 2,979
Can I do two validations on a cell?
You can do this with data validation and programming. There's a sample
file he
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0005 - Data Validation "Columns"'
wrote:
I have a validation on a cell which is bringing a list of code numbers. At
the same time in the same cell, I will like the names related to this codes
to show for users to be able to identify the name of these codes. How can I
do this?
Example:
List of codes Name of codes
15 Human Resource
33 Training
On the validation cell right now the list of codes is showing up, I want to
have the name of these codes showing as well when people are choosing the
code.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Reply With Quote
Debra Dalgleish
View Public Profile
Find all posts by Debra Dalgleish