Excel 2000 Text Box Issue
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
|