Question: Open a new workbook, get into the VBE, insert a user form, add a text boxnamedtxtLastName, and add a Last Name label to its left.

Open a new workbook, get into the VBE, insert a user form, add a text boxnamedtxtLastName, and add a Last Name label to its left. This text box issupposed to capture a persons last name. Therefore, it should contain alphabeti-cal characters only. You could perform an error check in aValidfunction subrou-tine, but you might want to check for nonalphabetical characters at the same timethe user is typing the name. You can do this with theChangeevent for a text box.In this case, the event handlers name istxtLastName_Change. This event fires

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!