I have this exact problem, but I need to use the OnChange event for a worksheet to set the value of a text box. Upon close, I get this error. Any solutions without changing to OnClick?