ComboxBox with Dynamically Defined Source, and LinkedCell error
 

Hi all,
I am having a problem with a Combobox. It's an ActiveX Combobox, embedded in
a worksheet, with the LinkedCell property set to point to a cell in the
worksheet.

When using Undo the Combobox updates a cell in another sheet, or even
another workbook.

I have recreated the bug, and it seems to be caused by having these:
a) A list of cells described by a dynamically defined name formula, e.g. ...
=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A$1:$A$14)-1,1)
b) A comboxbox ( ActiveX ), as an embedded object in another sheet in the
book, with ListFillRange being the previously defined name, and LinkedCell of
C2.

Then any change in any book followed by Undo causes the selected entry from
the combobox to magically appear in the book that you are editing, in cell
C2.

Glenn.

ComboxBox with Dynamically Defined Source, and LinkedCell error
 

More info ... this bug is happening in Excel 2003 and Excel 2007.

"GlennUK" wrote:

Hi all,
I am having a problem with a Combobox. It's an ActiveX Combobox, embedded in
a worksheet, with the LinkedCell property set to point to a cell in the
worksheet.

When using Undo the Combobox updates a cell in another sheet, or even
another workbook.

I have recreated the bug, and it seems to be caused by having these:
a) A list of cells described by a dynamically defined name formula, e.g. ...
=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A$1:$A$14)-1,1)
b) A comboxbox ( ActiveX ), as an embedded object in another sheet in the
book, with ListFillRange being the previously defined name, and LinkedCell of
C2.

Then any change in any book followed by Undo causes the selected entry from
the combobox to magically appear in the book that you are editing, in cell
C2.

Glenn.