Okay, I see what you want now. Try putting using this code in the macros you
have assigned to each drop down control...
Sub DropDown1_Change()
Worksheets("Sheet2").DropDowns("Drop Down 2").Value = _
Worksheets("Sheet1").DropDowns("Drop Down 1").Value
End Sub
Sub DropDown2_Change()
Worksheets("Sheet1").DropDowns("Drop Down 1").Value = _
Worksheets("Sheet2").DropDowns("Drop Down 2").Value
End Sub
adjusting the sheet names and drop down names for your actual situation.
Rick
"Bonobo" <(E-Mail Removed)> wrote in message
news:37B33C60-0868-4855-AA81-(E-Mail Removed)...
> Let's assume: Drop downlist A in Worksheet1 and Drop Down List B in
> Worksheet2.
> Both Drop Down Lists refer to the same list of possible data entry x, y,
> z.
>
> What I need:
> When I select entry x in Drop Down List A, Drop Down List B is
> automatcially
> updated to entry x. If I then change the entry in DropDown List B to z,
> Drop
> Down LIst A should automatically change to z.
>
> Hope this is clear enough.
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> And vice versa? Okay, that one threw me a little. Can you give us some
>> sample data that shows what you are trying to do?
>>
>> Rick
>>
>>
>> "Bonobo" <(E-Mail Removed)> wrote in message
>> news:9A3297D2-C06E-4548-961D-(E-Mail Removed)...
>> > Hello,
>> > I have two drop down lists (done with Forms) on two seperate
>> > worksheets. I
>> > would like them to be dependent so that when I make a selection on one
>> > of
>> > them the second one changes accordingly to the same entry (and vice
>> > versa).
>> > Can anyone help?
>>
>>
|
Similar Threads
