Hi
I enter data is a Textbox called TxtNewCode and then press "Enter" - the code then updates other TextBoxs on the form
PHP Code:Private Sub TxtNewCode_Exit(ByVal Cancel As MSForms.ReturnBoolean)
' Updating the form here
End Sub
When I exit the subroutine the Focus is passed to the next control on the form- How can I ensure that after the subroutine is exited that the focus is returned to the TxtNewCode textbox
Many thanks
Last edited by John Eakins; 09-28-2007 at 11:14 AM.
Hello John,
By setting the "Cancel" variable to True. This will prevent the focus from moving automatically to the next control in the Tab sequence.
Sincerely,
Please Login or Register to view this content.
Leith Ross
Hi Leith
Perfect - many thanks
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks