Cross changing values in dropdown lists

[djurkash]

Hi guys,
I am new in here, and as all other noobs, have to ask for a help.
I have 2 sheets, in both 2 drop down lists. These are dependable, meaning 1. dropdown in 1. sheet should be related to 1. dropdown in second sheet and reverse, and same for 2. dropdown.

I want following action: if I change one value in either of the dropdowns, this will update values in all.
This means that if:

1. I change the value in 1. dropdown of the first sheet, 1. dropdown in second sheet will get the same value from the 1. dropdown in 1. sheet, and in the same time 2.dropdown from the 2.sheet will get value from the 2.dropdown of the 1.sheet.

2. Also, if I go to 2. sheet, and change there value in for example 2.dropdown, I want that 2.dropdown from 1. sheet gets this value from the 2.dropdown of 2.sheet...

I know I am bit of confusing, but maybe my codes will clear the details:

Code for 1. sheet

Please Login or Register  to view this content.

Code for 2.sheet

Please Login or Register  to view this content.

Now, I know I could reduce this code putting in the if not intersect Range ("A1:B1") but I experimented this way.
Anyway, this above mentioned code is working only if I change both dropdowns in the same sheet, but as soon as I go to other sheet and change one dropdown, other is showing reference to go to error. In other words procedure doesn't know what to do first.

To make all more clear I will attach whole file:

Hope someone will read this, it isn't as complicated as it looks to be :-)

[JBeaucaire]

Since you're using VBA, you can just as easily put VALUES on each sheet as insert formulas. I think you should be able use just this:

Please Login or Register  to view this content.

Create another version like that for the other sheet.

Start things off by entering values in A1 and B1 of the first sheet, now you can switch back and forth after that.

[djurkash]

Since you're using VBA, you can just as easily put VALUES on each sheet as insert formulas. I think you should be able use just this:

Please Login or Register  to view this content.

Create another version like that for the other sheet.

Start things off by entering values in A1 and B1 of the first sheet, now you can switch back and forth after that.

You're right JBeaucaire, I knew it has to be the values I should call, but didn't know the right code.
Thanks a lot :-)

[JBeaucaire]

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.