Automate a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form that would allow users to enter information on a meeting participant (name, title, phone, etc). The problem is there is no way of know now how many participants there will be to enter. I am trying to use a macro to allow the person to check a box if they want to add another participant and another section would appear for them to fill out. But the macro isn't working. Is that because it is trying to change the format of the form?

Any ideas how to do this? Maybe a command button to "add additional participant"

Thank you!
 
I would create a userform with text boxes for items such as the date, time
and subject of the meeting and a listbox and a text box for the attendees.
The attendees would be entered one at a time into the text box and a command
button would be clicked to transfer the attendee to the list box and empty
the text box so that another attendee can be entered. In this way, a list
of attendees would be build up in the list box. When all of the attendees
had been entered, another command button would be clicked to transfer all of
the information into the respective places in the new document created from
the template.

To get started, see the article “How to create a Userform†at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
AJ said:
I am trying to create a form that would allow users to enter information
on a meeting participant (name, title, phone, etc). The problem is there is
no way of know now how many participants there will be to enter. I am
trying to use a macro to allow the person to check a box if they want to add
another participant and another section would appear for them to fill out.
But the macro isn't working. Is that because it is trying to change the
format of the form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top