Linking Combo Boxes

[Guest]

I have a month drop down menu, created using combo box, on a number of
worksheets. Each drop down menu referencs the same cells in format control.
However, when I change the month on one worksheet the other drop down menus
aren't updated. How do I link the drop menus so that when I change the date
on one worksheet, the drop down menus on the the other worksheets are updated?

 

[Guest]

Hi,
It works for (win2k/o2k). Have you set up both InputRange and CellLink?
Say i have one combobox on Sheet1 and one on sheet2. And on sheet called
Temp i have month values in A1:A12 and the returned values of the comboboxes
is B1. I set:
- sheet1: combobox InputRange: Temp!A1:A12 and Cell Link: Temp!B1
- sheet2: combobox InputRange: Temp!A1:A12 and Cell Link: Temp!B1

Regards,
Sebastien

 

[Tom Ogilvy]

Link them all to the same cell.

Run a macro that updates them.

--
Regards,
Tom Ogilvy

I have a month drop down menu, created using combo box, on a number of
worksheets. Each drop down menu referencs the same cells in format control.
However, when I change the month on one worksheet the other drop down menus
aren't updated. How do I link the drop menus so that when I change the date
on one worksheet, the drop down menus on the the other worksheets are

updated?

 

[Guest]

I have set up just as you describe, but it doesn't update the various
worksheets. However, I noticed that if I create the drop down menu in the
Temp folder everything works fine. It just breaks if I copy to another sheet
or create in another sheet. Is it possible that I have some kind of
protection turned on that is not allowing the drop downs to be updated?

Thx.