View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chaplain Doug Chaplain Doug is offline
external usenet poster
 
Posts: 127
Default How to Stop ReEntry

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