View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel 2000 Text Box Issue

have you looked at the TabKeyBehavior Property of each of the text boxes?

True Pressing TAB inserts a tab character in the edit region.
False Pressing TAB moves the focus to the next object in the tab order
(default).


--
Regards,
Tom Ogilvy


"Cory" wrote in message
oups.com...
I am currently working with a VBA UserForm with several text boxes on
it. I am experiencing an intermittant problem with a couple of them.

On occaision, when the user attempts to use the tab key to move to the
next control, the tab key is recognized in the control as a character
rather than moving to the next control. Is this a quirk of Excel? I
can find plenty of sources to allow this kind of behavior but have not
found anything to prevent it.

I am only using the BeforeUpdate and Exit events. In the BeforeUpdate
event I am checking for a numeric value and the exit event I am
formating the entry to currency.

Since I'm testing for a numeric value and the tab character is not
recognized as a number, my BeforeUpdate works as it should but the user
loses all the information that they entered.

The user can still move out of the text box with the mouse, but this
can be a bit of an annoyance.

Thanks for any help you can provide. Let me know if you need any
further information.

Cory Bremer