LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 493
Default validation - how to show the second column

I've highlited a column and put a validation having the range in a different
spreadsheet. In the spreadsheet with the range I have to columns - Code and
Description. But, for the validation I'm using only the first Code column for
data entries.
The validation is working well but a user entering Code can see only Code.
It would be nice to show the user the Description as well - not for entries
but just to see the Code's description.

How could I show the user the second column?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show Codes for Data Validation lists? Roady Excel Discussion (Misc queries) 1 May 25th 08 12:41 AM
one column of cells show ####. Values show when I open it. Help grantljg Excel Discussion (Misc queries) 3 September 18th 07 09:19 PM
show more items in validation list jenn Excel Worksheet Functions 1 December 11th 06 07:43 PM
Data Validation Drop Down List - Always Show Louise Excel Discussion (Misc queries) 1 September 18th 06 12:26 PM
Set Validation list to show top item Tod Excel Programming 3 June 29th 04 03:45 PM


All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"