Macro Trouble

[Nino]

I have made a simple macro, using a VBA Userform to ask for some
information(Name,adress) and then place that text at the right bookmarks.the
forms are saved as Word Templates

I ran in to 2 problems:
1: Once I filled in the required information in the userform and press the
ok, it places the information at the good marker, but once I het the enter
key(to type the next sentence) it places the userform info again(again it
fills the bookmarks with the info, Name/adress).

any idea's why?

2: second problem is the tab order in the VB Userform. I can't get it to
work.

Any ideas on this?

Any help will be welcome.

 

[John McGhie [MVP - Word and Word Macintosh]]

Hi Nino:

You need to add an OnExit macro to perform the action and reposition the
cursor.

For your second question, are you using the TabIndex property or the Tab
Order dialog? (See the VBA Help for more information...)

Cheers

I have made a simple macro, using a VBA Userform to ask for some
information(Name,adress) and then place that text at the right bookmarks.the
forms are saved as Word Templates

I ran in to 2 problems:
1: Once I filled in the required information in the userform and press the
ok, it places the information at the good marker, but once I het the enter
key(to type the next sentence) it places the userform info again(again it
fills the bookmarks with the info, Name/adress).

any idea's why?

2: second problem is the tab order in the VB Userform. I can't get it to
work.

Any ideas on this?

Any help will be welcome.

--

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

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

 

[Duckie]

thanks

I placed a unload userform1 command.
this stopped the first problem.

I managed to get the Tab start @ the top, by using:
Userform1.SetDefaultTabOrder.

but can't use the Tab button.

I used both ways to try and get it to work. in both ways he just
started @ the cancel button.
While I had that one set as last.

any ideas why?

 

[Sol Apache]

I¹m afraid tab order on a userform is one of those things which do not work
on a Mac but does in Word on a PC.

Another of several glitches in Word for the Mac that needs to be fixed...