Using linked cell to change value in combo box

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

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

I was able to solve my problem this morning by giving up trying to change the
value in the linked cell. Instead, I directly change the value in the combo
box and for some reason, totally unknown to me, that works fine without
changing any other code. It's not ideal for my purposes. But it's not worth
the struggle on anyone's part to try get the other way to work.

Thanks for responding.

----
eugene


"JLatham" wrote:

> 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