Re: Repeating Form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Razz (rzahab_at_claytonutz.com)
Date: 08/30/04 

Date: Tue, 31 Aug 2004 09:38:53 +1000

Im placing the data into a table of the original document. My code
currently looks like this:
    With Me
        ActiveDocument.tables(2).Cell(Row:=2, Column:=1).Select
        Selection.TypeText (.txtDate.Text)
        ActiveDocument.tables(2).Cell(Row:=2, Column:=2).Select
        Selection.TypeText (.txtFunction.Text)
        ActiveDocument.tables(2).Cell(Row:=2, Column:=3).Select
        Selection.TypeText (.txtClients.Text)
    End With
This works fine if I didnt it need the same frm to continue repeating upon
next.
Thank you :)

Im hitting reply to group so i hope it works this time.

"Doug Robbins" <dkr@NOmvpsSPAM.org> wrote in message
news:eh#d$UnjEHA.2688@TK2MSFTNGP15.phx.gbl...
> Where are the second and subsequent sets of data intended to go? Into the
> original document or is a new document to be created each time?
>
> --
> Please respond to the Newsgroup for the benefit of others who may be
> interested. Questions sent directly to me will only be answered on a
paid
> consulting basis.
>
> Hope this helps,
> Doug Robbins - Word MVP
> "Razz" <rzahab@claytonutz.com> wrote in message
> news:Ot00AkijEHA.3612@TK2MSFTNGP12.phx.gbl...
> > Hello
> >
> > Im using Word 2002 and VBA UserForms.
> > I have created a Userform named frmExpenses. When Next is selected on
> > frmExpenses, i need that data to transfer into the document and then
> > replay
> > the same userform (frmExpenses) as a new empty form ready for fill in.
> >
> > It should continue to repeat frmExpenses until cmdFinish is selected.
> >
> > Is this possible? I cant find much info on repeating vba forms.
> > Thank you.
> >
> > "Cindy M -WordMVP-" <C.Meister-C@hispeed.ch> wrote in message
> > news:VA.00009e1d.004afab3@speedy...
> >> Hi Razz,
> >>
> >> It's not quite clear what you have/want. Do you have a UserForm? Or
form
> >> fields in a document?
> >>
> >> If a UserForm (that's the impression I get), then you click a button
> >> ("Next"?) and the data is transferred into the document? And then what,
> > more
> >> exactly, do you need to have happen that you can't figure out?
> >>
> >> Oh, and which version of Word are we dealing with?
> >>
> >> > Can anyone help with coding that will make a form repeat.
> >> > I have a form that enters expenses and I would like this form to
> >> > repeat.
> >> > When data is entered on the first form, I need it to enter that text
in
> > the
> >> > document and so on, wile selecting the Next button. I have included
a
> >> > Finish button to end the repeat.
> >> >
> >>
> >> Cindy Meister
> >> INTER-Solutions, Switzerland
> >> http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
> >> http://www.word.mvps.org
> >>
> >> This reply is posted in the Newsgroup; please post any follow question
or
> >> reply in the newsgroup and not by e-mail :-)
> >>
> >
> >
>
>

Quantcast