Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Validation List

I want to use a listbox for a cell. But I want to have 2 different lists to
choose form based on what a certain cell is. EXAMPLE in cell A2 I want to
have a list box. Now if A1 shows "2418" then I want A2 to have a list showing
different options. And if A1 shows "2499" then I want A2 to have a list with
different options. Is this possibe? if so, how do I do it.
Thanks in advace

Travis
 
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
validation list Crispy Excel Worksheet Functions 1 April 9th 06 06:46 AM
update data validation list with new entries?? cjtj4700 Excel Discussion (Misc queries) 10 December 12th 05 01:00 AM
drop-down list validation won't allow a different worksheet justmetn Excel Worksheet Functions 4 September 15th 05 05:33 PM
Auto Update A Validation List Dmorri254 Excel Worksheet Functions 2 March 3rd 05 07:29 PM
list validation using list validation... Patrick G Excel Worksheet Functions 1 December 21st 04 12:37 AM


All times are GMT +1. The time now is 03:26 AM.

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

About Us

"It's about Microsoft Excel"