Problem with Undo and Combo boxes

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

Running Excel 2000. A relatively large sheet ~1.8Meg with
multiple tabs. For clarity sake Combo boxes are used on
Tab 1, Tab two is all formulas. Anytime the Undo button,
or <ctl> Z are used the values of the comboboxes on the
first tab are pasted in the same cell address on tab two.
The file has a good bit of VBcode behind it as well but
nothing with anything even remotely close to this kind of
behavior.
 
I'm not a VBA expert but, it sounds as if you have an
event in VBA that is firing. The event could be "On
exit", "On update", "On exit" etc. Using commands are
events. I suggest you take a close look at the VBA code.

Charlie O'Neill
 
I use xl2002, so even if I test, it may not prove anything.

But you may want to specify a little more for those who use xl2k--so they can
verify.

Are you comboboxes from the control toolbox toolbar or are they dropdowns from
the Forms toolbar (or even just data|validation cells). (They all have the same
kind of general appearance.)

Do you have code behind the comboboxes or macros assigned to the dropdowns or
even any worksheet events hanging around.

A little more description (no files, please) may help you get a better answer.

(and if you don't get a better answer, could you use either of the other two
instead?)
 
Back
Top