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?

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

"dogo" wrote:

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?

Link them all to the same cell.

Run a macro that updates them.

--
Regards,
Tom Ogilvy

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

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.

"sebastienm" wrote:

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

"dogo" wrote:

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?