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" wrote in message
...
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" wrote in message
...
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?