Forum Discussion
Cant get enter and exit functions to work properly
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar here is a copy of the program,, whne you open it, click on the "ECO" button, and it will take you to the form. If you click on the text boxes that I have changing color in the code, they do not resort back to the white color all the time, take a look and click around, see if you can see anything odd. Thanks much.
Thank you. I've clicked around hundreds of times, but the behavior was consistently correct.
I'm using Excel in Microsoft 365 version 2403 (32-bit) on Windows 11 Home version 23H2 (64-bit).
- we are using 365 , 2402 version. very confused,, did you click aroung from frqme to frame as well,,, the area I am having issues with is switching between the "update type" box and the "requester" boxes, did you try that one?
Yes, I did click from frame to frame, and more specifically from txtREQUESTERName to cmbUPDATEType and back, and it worked correctly every time.
But now it gets weird: when I reopened the workbook this morning, I did see the problem for some controls. I then closed and reopened the workbook, and it occurred for a different set of controls.
It seems that the Enter and Exit events do not always fire consistently.
One suggestion: add the line
txtDate_opened.BackColor = vbWhite
to fram_REQ_SPECIFIC_CHANGES_Enter and to fram_ENG_CHANGE_INFO_Exit.