Code an Event Procedure for Each Textbox

If you want to code an event procedure (such as GotFocus) for each textbox on a freshly designed form, you must switch manually from the Change event to the GotFocus event for each one. This can be annoying and tedious, especially when many textboxes dont belong to a control array. To get around this, double-click on each textbox on the form to generate an empty Change event procedure. Then do a find-and-replace, searching for “_Change” and replacing it with “_GotFocus.” Be careful not to do a “Replace All” unless theres very little other code in that form module already.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: