Tab key does not work in custom dialogs

[Markus Wolff]

I am developing macro applications in word, excel and powerpoint. Since
I upgraded to Office 2004 the custom dialogs built in the vba projects
won't respond to the tab key anymore. This seems to be a bug throughout
the whole office suite and is as well reported on the mactopia site.

Ist there a known workaround or announcement of correction?

Kind regards
Markus

 

[JE McGimpsey]

I am developing macro applications in word, excel and powerpoint. Since
I upgraded to Office 2004 the custom dialogs built in the vba projects
won't respond to the tab key anymore. This seems to be a bug throughout
the whole office suite and is as well reported on the mactopia site.

Ist there a known workaround or announcement of correction?

One workaround is to use each control's KeyDown event to set the focus:

Private Sub TextBox2_KeyDown( _
ByVal KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
If KeyCode = vbKeyTab Then
KeyCode = 0 'Don't pass TAB
Select Case Shift
Case 0 'no modifier keys
TextBox3.SetFocus
Case 1 'Shift key down
TextBox1.SetFocus
Case Else 'CMD or Option
'do nothing
End Select
End If
End Sub

There will almost certainly be no correction, since VBA and Userforms
are going away in the next version of MacOffice.

 

[Markus Wolff]

OK, thanks a lot that works.

Is there any documentation yet on how progarammability will be provided
in Office 2007 on Mac OS X, I've read the Apple Script Support will be
enhanced.

Regards
Markus

 

[JE McGimpsey]

Is there any documentation yet on how progarammability will be provided
in Office 2007 on Mac OS X, I've read the Apple Script Support will be
enhanced.

Applescript support is pretty good already for Word and XL 04, though
there are some significant bugs and limitations.

Office 08 will, at least in theory, be even better. However, there isn't
any official documentation of what will change that I know of.