View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GlennUK GlennUK is offline
external usenet poster
 
Posts: 2
Default 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.