inserting rows duplicates combobox's linkedCell

[factrac]

I have the a combo box that calls a macro when changed. Its linked cel
is positioned directly to its left. Far above the combo box, I wil
need to frequently insert and delete rows.

My problem is the following: whenever I insert a row, the value of th
combobox's linked cell is duplicated onto the cell above it, and when
remove a row, the value of the linked cell is duplicated onto the cel
below it.

The problem does NOT occur when I do not assign a macro to the comb
box. The problem DOES occur when I assign an empty macro to the comb
box (i.e. "sub nomacro() [newline] end sub").

Does anyone know how I can insert/remove rows above a combobox with
macro, without duplicating cell values? Has anyone ever heard of thi
error before? know what's causing it? been able to duplicate it?

Thank you in advance for any help.

-

 

[Dave Peterson]

I've never noticed it before either, but it occurred in xl2002 for me.

I put a dropdown from the Forms toolbar in B16 and used A16 as the linked cell.
I put the input range on a different sheet.

I inserted a new row 5 and son-of-a-gun, the linked cell's value was put in the
cell above the linked cell. (similar effect on the lower row if I deleted a
row.)

And if I inserted 6 rows, then the value was put in a cell 6 rows up.

But it wouldn't overwrite existing data.

Maybe you could use that as a workaround.

If you put something in those cells (even an apostrophe so it looks empty), then
it won't be overwritten.

I like to use a formula: =""
when I do stuff like this. I hope that when I see that formula, it'll remind me
that the cell is filled for some weird purpose and I won't clear it.

(And fill enough of the range with ="" so that you can insert as many rows (or
delete as many rows) as you want without worrying about if you overwrote one of
the blank cells.

I have the a combo box that calls a macro when changed. Its linked cell
is positioned directly to its left. Far above the combo box, I will
need to frequently insert and delete rows.

My problem is the following: whenever I insert a row, the value of the
combobox's linked cell is duplicated onto the cell above it, and when I
remove a row, the value of the linked cell is duplicated onto the cell
below it.

The problem does NOT occur when I do not assign a macro to the combo
box. The problem DOES occur when I assign an empty macro to the combo
box (i.e. "sub nomacro() [newline] end sub").

Does anyone know how I can insert/remove rows above a combobox with a
macro, without duplicating cell values? Has anyone ever heard of this
error before? know what's causing it? been able to duplicate it?

Thank you in advance for any help.

-m