Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application Defined error | Excel Discussion (Misc queries) | |||
Application-defined or object-defined error Please Help | Excel Discussion (Misc queries) | |||
Macro error : Application-defined or object-defined error | Excel Discussion (Misc queries) | |||
Combo Box "LinkedCell" option | Excel Discussion (Misc queries) | |||
Linkedcell protection problem | New Users to Excel |