Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 30th 07, 06:46 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 1
Default Create a drop down list dependent on selection from another list

I have 2 combo boxes in 1 sheet.

I'd like the results in the second to be dependent on the result selected
from the 1st.

Is this possible.

Thanks
Rosie

  #2   Report Post  
Old March 30th 07, 07:52 PM posted to microsoft.public.excel.programming
Eva Eva is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 197
Default Create a drop down list dependent on selection from another list

Click format control
cell link - put for example A1 (gives you the position on the list)
use index function to find results
Eva


"rosiep" wrote:

I have 2 combo boxes in 1 sheet.

I'd like the results in the second to be dependent on the result selected
from the 1st.

Is this possible.

Thanks
Rosie

  #3   Report Post  
Old March 30th 07, 08:22 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default Create a drop down list dependent on selection from another list

Check out this link...

http://www.xldynamic.com/source/xld.Dropdowns.html
--
HTH...

Jim Thomlinson


"rosiep" wrote:

I have 2 combo boxes in 1 sheet.

I'd like the results in the second to be dependent on the result selected
from the 1st.

Is this possible.

Thanks
Rosie



Reply
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
Create a list in a drop down dependent upon another dd list in exc fyrefox Excel Discussion (Misc queries) 1 August 9th 07 08:46 PM
Return a list dependent upon the selection of a preceeding list Aja K Excel Worksheet Functions 4 April 11th 07 07:48 PM
lists dependent on preceding list selection Weissme Excel Discussion (Misc queries) 1 August 10th 06 03:45 AM
create 2nd list dependent on 1st list Mike Excel Worksheet Functions 3 June 14th 06 09:21 PM
How do I create a dependent list, to a current list? elevenphil Excel Discussion (Misc queries) 1 January 30th 06 05:35 PM


All times are GMT +1. The time now is 06:50 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017