Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link data from one drop-down list to another
Hi, I Excel 2003 I have 3 drop-down lists. In list one is 1,2,3. In list 2 it is A,B,C. In list three it is $,€,*. Which function do I need to link 1 (from list one), to B (in list two), to $ (in list three). So if I select 1 in list one B will automtically appear in list two and $ automatically in list three. Can anyone help me to solve this? -- dolfijntje33 ------------------------------------------------------------------------ dolfijntje33's Profile: http://www.excelforum.com/member.php...o&userid=34593 View this thread: http://www.excelforum.com/showthread...hreadid=543659 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link data from one drop-down list to another
See http://www.contextures.com/xlDataVal02.html
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "dolfijntje33" wrote in message news:dolfijntje33.281umm_1148033405.9719@excelforu m-nospam.com... Hi, I Excel 2003 I have 3 drop-down lists. In list one is 1,2,3. In list 2 it is A,B,C. In list three it is $,?,*. Which function do I need to link 1 (from list one), to B (in list two), to $ (in list three). So if I select 1 in list one B will automtically appear in list two and $ automatically in list three. Can anyone help me to solve this? -- dolfijntje33 ------------------------------------------------------------------------ dolfijntje33's Profile: http://www.excelforum.com/member.php...o&userid=34593 View this thread: http://www.excelforum.com/showthread...hreadid=543659 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link data from one drop-down list to another
I already seen that solution. Unfortunatly that is nog what I mean. In that example you still need to make a selection in list 2 and/or 3. In my case I want to make a selection in list one and that list 2 and list 3 automatically sets the value that was give to the list item selected in list one. So... If in list one "1" is selected, in list 2 and 3 automatically the values B and $ will appear without having to use the drop-down list there. -- dolfijntje33 ------------------------------------------------------------------------ dolfijntje33's Profile: http://www.excelforum.com/member.php...o&userid=34593 View this thread: http://www.excelforum.com/showthread...hreadid=543659 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link data from one drop-down list to another
You would need VBA for that, and your lists would have to be in ranges. Is
that the case for you? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "dolfijntje33" wrote in message news:dolfijntje33.281zho_1148039705.2035@excelforu m-nospam.com... I already seen that solution. Unfortunatly that is nog what I mean. In that example you still need to make a selection in list 2 and/or 3. In my case I want to make a selection in list one and that list 2 and list 3 automatically sets the value that was give to the list item selected in list one. So... If in list one "1" is selected, in list 2 and 3 automatically the values B and $ will appear without having to use the drop-down list there. -- dolfijntje33 ------------------------------------------------------------------------ dolfijntje33's Profile: http://www.excelforum.com/member.php...o&userid=34593 View this thread: http://www.excelforum.com/showthread...hreadid=543659 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link data from one drop-down list to another
Here is an example of the code in such a case
Option Explicit '----------------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) '----------------------------------------------------------------- On Error GoTo ws_exit: Application.EnableEvents = False With Target If .Address = "$A$1" Then .Offset(0, 1).Value = Application.Index(Range("List2"), _ Application.Match(.Value, Range("List1"), 0)) .Offset(0, 2).Value = Application.Index(Range("List3"), _ Application.Match(.Value, Range("List1"), 0)) ElseIf .Address = "$B$1" Then .Offset(0, -1).Value = Application.Index(Range("List1"), _ Application.Match(.Value, Range("List2"), 0)) .Offset(0, 1).Value = Application.Index(Range("List3"), _ Application.Match(.Value, Range("List2"), 0)) ElseIf .Address = "$C$1" Then .Offset(0, -2).Value = Application.Index(Range("List1"), _ Application.Match(.Value, Range("List3"), 0)) .Offset(0, -1).Value = Application.Index(Range("List2"), _ Application.Match(.Value, Range("List3"), 0)) End If End With ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Bob Phillips" wrote in message ... You would need VBA for that, and your lists would have to be in ranges. Is that the case for you? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "dolfijntje33" wrote in message news:dolfijntje33.281zho_1148039705.2035@excelforu m-nospam.com... I already seen that solution. Unfortunatly that is nog what I mean. In that example you still need to make a selection in list 2 and/or 3. In my case I want to make a selection in list one and that list 2 and list 3 automatically sets the value that was give to the list item selected in list one. So... If in list one "1" is selected, in list 2 and 3 automatically the values B and $ will appear without having to use the drop-down list there. -- dolfijntje33 ------------------------------------------------------------------------ dolfijntje33's Profile: http://www.excelforum.com/member.php...o&userid=34593 View this thread: http://www.excelforum.com/showthread...hreadid=543659 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link data from one drop-down list to another
If this example code is correct as I cannot read VBA script.:-( -- dolfijntje33 ------------------------------------------------------------------------ dolfijntje33's Profile: http://www.excelforum.com/member.php...o&userid=34593 View this thread: http://www.excelforum.com/showthread...hreadid=543659 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link data from one drop-down list to another
If you name the lists as List1, List2, and List3 and the DV is in A1, B1 and
C1, then yes. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "dolfijntje33" wrote in message news:dolfijntje33.28251n_1148046905.0947@excelforu m-nospam.com... If this example code is correct as I cannot read VBA script.:-( -- dolfijntje33 ------------------------------------------------------------------------ dolfijntje33's Profile: http://www.excelforum.com/member.php...o&userid=34593 View this thread: http://www.excelforum.com/showthread...hreadid=543659 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List Font Size in Data Validation | New Users to Excel | |||
drop down list that changes the data of 3 other cells | New Users to Excel | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
link email to drop down list | Excel Discussion (Misc queries) | |||
link to result from drop down list | Links and Linking in Excel |