Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / December 2007

Tip: Looking for answers? Try searching our database.

Record Macro in a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
E-mail report using Lotus Notes rather t - 05 Dec 2007 22:25 GMT
Hi,

I it possible to create a new macro in a form.  Basically I there are
certain fields in the form that I would like to duplicate for an another
form.  Is this possible to record the field I want to duplicate in a macro
recording in a form?
zkid - 07 Dec 2007 01:35 GMT
Not quite sure what it is that you're asking.  Can you restate the question
please?

> Hi,
>
> I it possible to create a new macro in a form.  Basically I there are
> certain fields in the form that I would like to duplicate for an another
> form.  Is this possible to record the field I want to duplicate in a macro
> recording in a form?
E-mail report using Lotus Notes rather t - 07 Dec 2007 17:29 GMT
Hi zkid,

I have three form created in MS Word.  There about 34 fields on average on
each form.  However, there are about 10 fields that are identical in all of
the forms.  What I am trying to do is use a macro to record only the fields
that are identical for each of the form.  So when I populate the first form i
can use a macro of some kind and record the identical fields and then open
the 2nd and 3rd form and activate the macro to automatically populate the
identical fields in form 2 and 3.  Is it possible to use macro instead of
userform?  I actually experimented with the recording of macro but I was not
able to make it work.  When I lock the form fields so I can begin populating
the form, the create macro does not work or inactive.  So, I am not even sure
if macro works on capturing fields being pupulated in a form.

> Not quite sure what it is that you're asking.  Can you restate the question
> please?
[quoted text clipped - 5 lines]
> > form.  Is this possible to record the field I want to duplicate in a macro
> > recording in a form?
zkid - 07 Dec 2007 17:58 GMT
Okay, I'm still confused here.  I not sure what you mean by "recording a
field."  

Are you trying to copy the entire field code, or just its result (e.g., what
the user types in)?

Also, are we talking about formfields, or field codes?

> Hi zkid,
>
[quoted text clipped - 19 lines]
> > > form.  Is this possible to record the field I want to duplicate in a macro
> > > recording in a form?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.