Tabs in Text Boxes
 

Anyone any idea why when I press tab key I get a tab in the text box?
TabKeyBehavior = False
If I Alt Tab twice (out of XL & back again) it starts working properly!

Tabs in Text Boxes
 

I believe the TabKeyBehavior is the control to tab (move) between different
objects on that form, not to eliminate an actual tab you may perform in the
textbox. Using an ALT TAB will alternate between different running programs
within all of Windows. When you ALT TAB back into MS Excel, I'll bet your
form (or the textbox within the form) isn't selected any longer.

Just my thoughts...


"Graham Y" wrote in message
...
Anyone any idea why when I press tab key I get a tab in the text box?
TabKeyBehavior = False
If I Alt Tab twice (out of XL & back again) it starts working properly!