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

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

--
Regards,
Tom Ogilvy

"Chaplain Doug" wrote in message
...
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

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