Option to add data to next row

[Sony]

I have created a protected form that has the
functionality of entering up to 20 rows of data. I am
using a Userform to populate each column (which works for
Row 1), but I want the ability to ask the user if they
want to enter more data. If yes is returned I want the
user form to pop up and when it is filled out then it
would populate the next available row. Any suggestions?

Thank you in advance.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Sony,

If I was the user, that would drive me crazy. Instead of doing it that way,
I would have a multicolumn listbox on a user form and a of textbox control
for each column plus an Add Item button and a Continue button. After
filling in the textbox controls, the user would click the Add Item button
which would add the data to the list box. This process they could repeat as
often as required and when finished, they would click the continue button
and then the data would be transferred from the listbox to the table in the
document.

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