Using linked cell to change value in combo box
It may be helpful to see what your macro is doing when it is called. That
is, put the code up here to so we can see if it is perhaps setting up a
condition that is either perpetually looping or even reiteratively calling
itself.
"eugene" wrote:
Hi really helpful people
I have a combo box created using control toolbox that is linked to a
worksheet cell. When the value in the combo box is changed it triggers macro
that works well and the value in the linked cell also changes. When I
manually change the value in the cell, the combo box value changes and that
triggers the macro. This also works well.
Here's the but..
When I change the linked cell value within a macro, it does what it is
supposed to but then bombs. Excel sends me this nasty message that it can't
handle what I want to do; it has run out of memory, etc.
Any idea what might be going wrong?
--
eugene
|