Does anyone know how to add the below cancel argument, allowing the user to exit the textbox when done?
"Each UserForm TextBox has an Exit event. There is an named argument Cancel which is a Boolean value. If you set this to True, then the focus will not move to the next control in the Tab Order. It will remain with the TextBox".[/I]
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
??
??
?? how do I code this?
Hi, Idahoanne,
AFAIR Cancel is used to keep the focus on the textbox.allowing the user to exit the textbox when done?
If you do not use the Cancel argument the user may leave the textbox.It will remain with the TextBox
Keep the focus on Textbox
Letting go use this code or omitt the event:
Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
If I put cancel = true, then the cursor remains in the textbox (which is great while they are entering data), but the user cannot exit the textbox. they cannot hit escape, or use to the mouse to click another button. they are stuck.
Do you know a way to put in an argument, that allows the user to exit, when done using the textbox?
You don't need to do anything for that. By default a user can leave a text box whenever they want. You only need the Cancel argument if you want to stop them - for example they filled it incorrectly.
Everyone who confuses correlation and causation ends up dead.
Hi, Idahoanne,
maybe this can give you an idea as you do not supply any hint on a correct filling (here the length of the entry):
Ciao,Please Login or Register to view this content.
Holger
Course_Roster_TEST2.xlsm
when I use the code above, the cursor does not return to the textbox, it goes back to the Register button. The user has to either click back into the textbox, or hit enter to go back. do you know a way to return the cursor to the textbox? I've attached a copy of the file. thank you for your help with this!
Hi, Idahoanne,
if it´s UserForm2 you´re talking about the code is working fine: I have to close the UF using the X as no other control is available on that form (using Excel2013 on this). You might consider to get away from letting the users type in every information into textboxes and offer either Listboxes or CombBoxes to choose from instead.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks