Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a form with 3 text boxes. What I want is the TAB key to send
the user to the next control. The problem I am having is that sometimes the TAB key will just add a TAB character to the text box value. Is there a control or property I need to set/change. The only thing I have in the txtForm_Change() subroutine is "txtForm.Value = UCase(txtForm.Value)" to force the value to upper case (maybe there another/better way to accomplish this?). Thanks for any help. -pb |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Set the TabKeyBehavior property to false for each Textbox. You can do that in the VBE properties window or with code. -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (Data Options add-in: insert or delete rows/date picker/random stuff) "pb" wrote in message ... I have a form with 3 text boxes. What I want is the TAB key to send the user to the next control. The problem I am having is that sometimes the TAB key will just add a TAB character to the text box value. Is there a control or property I need to set/change. The only thing I have in the txtForm_Change() subroutine is "txtForm.Value = UCase(txtForm.Value)" to force the value to upper case (maybe there another/better way to accomplish this?). Thanks for any help. -pb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
importing undelimited text file data, character-by-character | Excel Programming | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |