Simple - how to select textbox using vba
Posted on 2004-09-10
Simple question for you - how do I select all the text of a text box using vba?
I have a form where the user inputs a value into a textbox, some code runs checking if it's valid, and if not I have...
varans = MsgBox("The CDB you entered is not valid, please retype", vbCritical, "Invalid CDB")
What I want is for it to automatically go back to the textbox, preferably with the old input text higlighted. At the moment however it skips to the next input item on the form.
Thanks for your help - I'm learning on the job here :)