How to Stop ReEntry

[Chaplain Doug]

Excel 2003. I have a control (combo box) call JD on one of my sheets. I
have a subroutine that runs whenever the control changes (JD_Change). Thie
code in JD_Change makes some updates to the sheet (like writing data into
some cells). Everytime data is written to a cell on the page it triggers the
JD_Change event and the JD_Change routine is reentered (while it is still
running from the last change event). How may I keep the change events from
being reentered? Thanks for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

[Tom Ogilvy]

Without having first hand knowledge,
Try using the click event rather than the change event.

--
Regards,
Tom Ogilvy

"Chaplain Doug" <[email protected]> wrote in message
news:[email protected]...
> Excel 2003. I have a control (combo box) call JD on one of my sheets. I
> have a subroutine that runs whenever the control changes (JD_Change).
Thie
> code in JD_Change makes some updates to the sheet (like writing data into
> some cells). Everytime data is written to a cell on the page it triggers
the
> JD_Change event and the JD_Change routine is reentered (while it is still
> running from the last change event). How may I keep the change events
from
> being reentered? Thanks for the help.
> --
> Dr. Doug Pruiett
> Good News Jail & Prison Ministry
> www.goodnewsjail.org

[Greg Wilson]

I can only replicate this affect if the sub procedure changes cell(s) within
the control's ListFillRange and/or the control's LinkedCell is within the
ListFillRange. This is logical because changing a cell within the
ListFillRange changes the contents of the control's list which elicits the
change event again.

Regards,
Greg Wilson