Multi-Sheet Worksheet_Change event

[Baseball17Bucks]

Hi there,

Pretty new to macros - and brand new to the Worksheet_Change event (which is what I think I need help with).

Here's what I want to do...

• I have three worksheets - Sheet1, Sheet2, and Sheet3.
• In cell C1 of each of these sheets, I have a drop down list box (i.e. data validation) which can say "Project", "Phase 1", or "Phase 2".
• If a user changes cell C1 on any of these worksheets, I want cell C1 in the OTHER worksheets to change to the same value.

Does anyone have code to do this? Thanks for the help!

~ JF

[mikerickson]

If you put this in the ThisWorkbook code module, it should do what you want.

Please Login or Register  to view this content.

[Baseball17Bucks]

SOLVED.