Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
tabstops in userforms
Posted by L. van der Steen on October 21, 2001 11:18 AM
say, I have a textbox in which I want a specific type of data entered which I can only check 'afterupdate'. The information I want is not entered and I want the user to have to enter in the same textbox again. How do I automatically go to this textbox; this way also compelling the user to enter data, for instance a registration number, date or such. I have tried working with the set focus commands or manipulating with tab stops, but it don't wanna do what I wan'it to do. Can anybody help me?
| Check out our Excel VBA Resources
|
 |
 |
 |
 |
 |
Re: tabstops in userforms
Posted by Jonathan on October 21, 2001 11:33 AM
Put a Cancel=True in the Exit event of the control if you don't get the value in the control that you accept. Then focus never leaves the control , you don't have to re-Set it.
HTH
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.