| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting tab order by code
I have a form that has 4 text boxes and two buttons. When an invalid
entry is found I want the focus to be set to the originating text box. Now when you press enter and the invalid entry is discovered the focus is set to the next tab box even when I set the focus back to the original text box. Any ideas? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting tab order by code
Use the Exit event to do the validation, then set cancel = True to stay in
the text box if you decide the entry is invalid. -- Regards, Tom Ogilvy dlrauh wrote in message ... I have a form that has 4 text boxes and two buttons. When an invalid entry is found I want the focus to be set to the originating text box. Now when you press enter and the invalid entry is discovered the focus is set to the next tab box even when I set the focus back to the original text box. Any ideas? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting reverse order for axis in OWC 11 chart component | Charts and Charting in Excel | |||
| Setting Tab order | Excel Discussion (Misc queries) | |||
| Setting the Tab Order | Excel Discussion (Misc queries) | |||
| Setting custom Tab order | Setting up and Configuration of Excel | |||
| setting order in excel | Excel Discussion (Misc queries) | |||
Linear Mode
