I have come across what I think is an excel bug, or maybe I have done something wrong. I'm using excel 2007<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
I have created several dynamically named range that is used to fill active X combo boxes embedded on a worksheet.<o
></o
>
<o
></o
>
My named ranges are declared like this <o
></o
>
=OFFSET('Lookup Tables'!$G$1,1,0,COUNTA('Lookup Tables'!$G:$G),1)<o
></o
>
<o
></o
>
I then use the name in the ListFillRange property of a combo box that is on another worksheet. The combo boxes are linked to the cells underneath them.<o
></o
>
<o
></o
>
I also use vba code to update the ListFillRange to get around the problem where the combo boxes don't update the list. But this is unrelated to the problem.<o
></o
>
<o
></o
>
Private Sub ComboBox1_GotFocus()
ComboBox1.ListFillRange = "MyRange"
End Sub<o
></o
>
<o
></o
>
This appeared to works fine without any problem.<o
></o
>
Eventually I noticed that I experience strange behavior whenever I used 'Undo' (button or ctrl z). <o
></o
>
<o
></o
>
If I was on a different worksheet than the one with the combo boxes and used 'undo' excel would undo the last change properly but would also paste the combo boxes linked cells onto that worksheet.<o
></o
>
So if the linked cells were B1 B2 and B3 those values would appear on the current worksheet in cells B1 B2 and B3 including all the formatting.<o
></o
>
<o
></o
>
Also if I opened another workbook and tried to undo while the problem workbook is open it crashes excel.<o
></o
>
<o
></o
>
Removing all the vba code didn't fix the problem.<o
></o
>
Changing the dynamic ranges to static did fix the problem.<o
></o
>
<o
></o
>
I just wanted to know if I have done something wrong or if it is a excel bug?<o
></o
>
Has anyone come across this before?<o
></o
>
<o
></o
>
Will I have similar problems with dynamic ranges and a combo box on form?<o
></o
>
Should I try vba code to change a static named range when a new entry is added?<o
></o
>
<o
></o
>
I hope that is clear enough, thanks in advance for any help.<o
></o
>




<o


I have created several dynamically named range that is used to fill active X combo boxes embedded on a worksheet.<o


<o


My named ranges are declared like this <o


=OFFSET('Lookup Tables'!$G$1,1,0,COUNTA('Lookup Tables'!$G:$G),1)<o


<o


I then use the name in the ListFillRange property of a combo box that is on another worksheet. The combo boxes are linked to the cells underneath them.<o


<o


I also use vba code to update the ListFillRange to get around the problem where the combo boxes don't update the list. But this is unrelated to the problem.<o


<o


Private Sub ComboBox1_GotFocus()
ComboBox1.ListFillRange = "MyRange"
End Sub<o


<o


This appeared to works fine without any problem.<o


Eventually I noticed that I experience strange behavior whenever I used 'Undo' (button or ctrl z). <o


<o


If I was on a different worksheet than the one with the combo boxes and used 'undo' excel would undo the last change properly but would also paste the combo boxes linked cells onto that worksheet.<o


So if the linked cells were B1 B2 and B3 those values would appear on the current worksheet in cells B1 B2 and B3 including all the formatting.<o


<o


Also if I opened another workbook and tried to undo while the problem workbook is open it crashes excel.<o


<o


Removing all the vba code didn't fix the problem.<o


Changing the dynamic ranges to static did fix the problem.<o


<o


I just wanted to know if I have done something wrong or if it is a excel bug?<o


Has anyone come across this before?<o


<o


Will I have similar problems with dynamic ranges and a combo box on form?<o


Should I try vba code to change a static named range when a new entry is added?<o


<o


I hope that is clear enough, thanks in advance for any help.<o

