Hi all,

Setting Application.EnableEvents = false can prevent other events from
happening, but how to achieve the same effect when doing with the controls
such as a textbox
on a form when the textbox is assigned a value without causing Change event
to happen

Clara
--
thank you so much for your help