Rlb53
08-30-2011, 05:51 PM
Johnny did a whole lot of work to set a process up for Suzy.
Johnny built a Userform with numerous textbox' for Suzy to easily fill in with data.
Suzy being impatient and in a hurry, she clicks on the command button to save the information with critical data not entered into some of the required textbox'.
Well.. Johnny knew Suzy very well and he setup the userform to display a message to Suzy that she had overlooked inserting information into a given textbox.
This helps tremendously to be certain that Suzy does not leave out any critical data.
But.. Suzy being Suzy... always in a hurry... she's TOLD Johnny that he needs to change something up.
After Suzy clicks on the command button, the message displays telling her to insert needed information into a specific textbox. When Suzy closes the messagebox, she still has to find and click on the textbox within the userform so it will recieve the information she should have inserted to start with.
Suzy wants Johnny to fix the userform so that after she closes the messagebox, the selected textbox will automatically be ready to recieve the required information without clicking on it again.
Johnny is asking for a little help to satisfy Suzy's request.
How could the simple code below be modified to prepare textbox5 to recieve information after the msgbox is closed?
Johnny say's Thank you!
If TextBox5.Value = NullString Then
MsgBox " Enter Vendor's City"
Exit Sub
End If
Johnny built a Userform with numerous textbox' for Suzy to easily fill in with data.
Suzy being impatient and in a hurry, she clicks on the command button to save the information with critical data not entered into some of the required textbox'.
Well.. Johnny knew Suzy very well and he setup the userform to display a message to Suzy that she had overlooked inserting information into a given textbox.
This helps tremendously to be certain that Suzy does not leave out any critical data.
But.. Suzy being Suzy... always in a hurry... she's TOLD Johnny that he needs to change something up.
After Suzy clicks on the command button, the message displays telling her to insert needed information into a specific textbox. When Suzy closes the messagebox, she still has to find and click on the textbox within the userform so it will recieve the information she should have inserted to start with.
Suzy wants Johnny to fix the userform so that after she closes the messagebox, the selected textbox will automatically be ready to recieve the required information without clicking on it again.
Johnny is asking for a little help to satisfy Suzy's request.
How could the simple code below be modified to prepare textbox5 to recieve information after the msgbox is closed?
Johnny say's Thank you!
If TextBox5.Value = NullString Then
MsgBox " Enter Vendor's City"
Exit Sub
End If