Strange form behavior (text boxes and tabbing)

[K Hindall]

I am building a UserForm in the VBE to be used to enter data into an
Excel worksheet.

It's pretty much done except for two *very* weird things.

First, the font shifts from one text box to the next. In the properties
they're all set to 12 pt. Osaka. (Osaka is the default Japanese font for
Mac, and my users are Japanese, although I'm working in the English
Excel 2004, set to a Japanese application in Microsoft's language
register so that I can view and handle Japanese text.) The first two
textboxes are in fact Osaka 12, but text boxes 3 through 8 are all
something larger, maybe 14 pt. Box 9 is back at Osaka 12, box 10 is the
larger font, and boxes 11 and 12 are Osaka 12 again. I can't figure for
the life of me what's going on there.

The textboxes are also all supposedly set to have a height of 20, but
they plainly don't. I can tell, just with the plain eyeball, that boxes
1 and 2 are larger than the rest. I even tried using the command via
the Format menu to try to get them the same height, but it didn't help.

Last but certainly not least, the tab key does not tab through the form.
I've checked my tab order, along with the TabIndex, Locked, TabStop, and
AutoTab properties on all my controls. The cursor stubbornly sits in
textbox 1 and won't budge.

Can anyone explain what is causing this mysterious behavior? Thanks!

K

 

[JE McGimpsey]

Last but certainly not least, the tab key does not tab through the form.
I've checked my tab order, along with the TabIndex, Locked, TabStop, and
AutoTab properties on all my controls. The cursor stubbornly sits in
textbox 1 and won't budge.

Can anyone explain what is causing this mysterious behavior? Thanks!

I haven't checked out the font issue, but not tabbing is a known bug -
and a real PITA. MacBU knows about it, but hasn't announced any plans to
fix it (they don't announce plans to fix other bugs, either, of course).

 

[K Hindall]

Well, I have a little more information on the tabbing problem at any
rate.

Although TabKeyBehavior is set to False in the properties for all the
text boxes, nonetheless it is behaving as if they were set to true. Is
this because the computer does not see a tab when I'm in the Japanese
keyboard as the same as the one in the English keyboard?

 

[Jim Gordon MVP]

Hi

Microsoft knows about the problem with TAB and form fields. We can only wait
for a fix from Microsoft. There's nothing to be done by us users.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.

 

[K Hindall]

I haven't checked out the font issue, but not tabbing is a known bug -
and a real PITA. MacBU knows about it, but hasn't announced any plans to
fix it (they don't announce plans to fix other bugs, either, of course).

Well, thanks, folks, that at least clears up the tabbing question. One
almost wonders why Microsoft bothered to implement UserForms on the
Macintosh if you can't tab through them. I have several theories on
that matter, but none of them polite so I'll skip 'em. I even searched
their site for enlightenment and didn't find a bug report.

Now I'm not sure that the font issue matters. I have my doubts that my
boss will want the form now. But if anyone has an idea on that score,
I'd still like to hear.

Thanks again!

K

 

[hughg]

Hi
Office 10 works with tabbing. If you need to use this, don't buy office
2004 untill the bug is fixed.