3/31/2024 0 Comments Excel vba on exit eventChanging the event from exit to afterupdate corrected this. I then discovered that the exit events didn't kick in if, instead of tabbing out of the field, I deliberately placed focus in a control elsewhere on the form.This resulted in me using the exit event for all except the last textbox in the frame that used afterupdate instead If you tabbed out of the last textbox in the frame, the exit event never kicked in (this is documented in other topics but took some time to find).I started off using the exit event but ran into 2 problems. The user enters a currency value and once they leave the control, then a protected textbox next to it shows the corresponding value in SEK. I have a userform with frames containing textboxes. Thought I'd kick off with my 2 cents' worth. Thought I'd start this topic since there seem to be a number of topics where the answer seems to be to use one of the above rather than other.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |