Re: How to Make Tabbing work from VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Gary:

No. We have never made it work. It's buggy, and they're not going to fix
it (because VBA is deprecated).

Microsoft has made the decision to retire VBA because by design it cannot be
adequately secured. Consequently, they are not going to put any further
development effort into it.

On the PC, use VBA.NET (or C sharp...). VBA.NET is actually a different
language that just happens to have similar syntax.

On the Mac, use AppleScript. Microsoft is putting all the available
(limited) resources into fixing and enhancing AppleScript as its Mac Office
scripting language. Alternatively, re-express your design in RealBasic,
which ships as an optional install for Mac Office.

Cheers


On 30/1/06 8:09 PM, in article C00317CD.42B%garyh@xxxxxxxxxxxx, "Gary
Hillerson" <garyh@xxxxxxxxxxxx> wrote:

> I'm trying to figure out how to get tabbing from field-to-field to work in
> userForms I'm creating with VBA in Word 2004 on the Mac. Right now, the only
> way to change focus is to click the mouse in another textbox, even tho the
> tab key properly generates an Exit event.
>
> As a simple test, I create a simple form with four controls: TextBox1,
> TextBox2, TextBox3, and a Cancel button that unloads the form.
>
> I implement the _Enter and _Exit methods of each textbox to display a debug
> message, e.g. "TextBox2_Enter"
>
> I type something into TextBox1 and then press the Tab key.
>
> I get an Exit event on TextBox1, and an Enter event on Textbox2, as
> expected.
>
> But then, I immediately see TextBox2_Exit, TextBox3_Enter, TextBox3_Exit,
> and TextBox1_Enter. The net result is that the same control (TextBox1) ends
> up with the focus.
>
> Even manually calling the SetFocus method of one textbox from another's Exit
> method doesn't work; the focus always cycles back to the textbox in which I
> press the Tab key.
>
> There must be some way to work around this tabbing problem, but I'm not
> finding it. Can anyone help?
>
> thanks
>
> Gary
>

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <john@xxxxxxxxxxx>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

.

Relevant Pages

  • Re: Parameter query based on text field
    ... In each each OnClick event of the textbox controls you would like to call ... window and click the menu option View> Immediate Window ... Microsoft Access does not like. ... | From: "Tom" ...
    (microsoft.public.access.queries)
  • Re: Distributable Commercial Apps Access Vs Delphi
    ... VBA is easy to use, but since it is a high level ... but it just can't compete with OOP based platforms. ... The newer platform, .Net, also created by Microsoft, overcomes the ... Dim txt As TextBox = TextBox1 ...
    (comp.databases.ms-access)
  • Re: VB Code Access 2002 Form
    ... changed the textbox in my form to that name. ... am getting the same error message but its referring to ... >(located within/under the ImageFrame control) and is ... >Cheryl Fischer, MVP Microsoft Access ...
    (microsoft.public.access.formscoding)
  • Re: MAX Function
    ... >><MS ACCESS MVP> ... >>> Microsoft Access Support ... >>> Microsoft Security Bulletin MS03-026? ... >>> | I need, in another textbox, look the max value of the ...
    (microsoft.public.access.reports)
  • Re: Rotateable text boxes (text rotates with the box)
    ... in Excel at least you can cut the textbox and use Edit/Paste Special ... > This post is a suggestion for Microsoft, ... To vote for this suggestion, ...
    (microsoft.public.office.misc)