#1
|
|||
|
|||
Allow user to add rows to Word '03 table....how?
I have a form which includes an 8 column table, each cell in the row has a Text Form Field with various lengths/output formats. My problems are two fold:
1) I need to allow users to insert additional rows if needed, the new row needs to contain the same empty Text Form Fields and I cant for life of me figure out how to do this. 2) I need to auto sum one of the columns by adding the bookmarks for each cell above in that column....if users add additional rows I'm lost..... I've created a similar form for a similar purpose but that form has a fixed number of rows. I was unable to use {=SUM(ABOVE)} as some cells may remain blank. Adding default values to the cells was unacceptable for end users, so I went with blanks and writing an excessively long formula to add 15 bookmarks. Bulky and complicated, but it works... I suppose users would need to make some condition "True" (entering "Y" in a Text Field, clicking a button, something) and then have the new row appear, 1 row per one click. Any suggestions are greatly appreciated. PMR |
#2
|
||||
|
||||
See 'Add a row to a table in a protected form' at: http://www.gmayor.com/word_vba_examples.htm
For the summing problem, perhaps the simplest solution is to split the table (which will also make it easier to add the new rows), bookmark it, then use a formula field coded like: {=SUM(MyTable C:C)} where 'MyTable' is the bookmark name and 'C' is the column you want to sum.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you, sir! I've been searching Word/Window forums for nearly a week, I don't know how I managed to not find that thread before. Also, thanks for the split table/code field advice, it is truly appreciated. I've actually read dozens of your replies to other users, when I saw your name in the response e-mail I read this morning, I was pleased knowing I would receive a helpful reply instead of another "I don't know how to answer your question so I would do something else...." answer that I've been getting elsewhere.
Thanks again! |
Tags |
conditional, insert row, tables |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Odd behaviour of table - keep rows together | Stephan Lindner | Word Tables | 1 | 09-10-2011 05:31 AM |
adding rows to word table | hklein | Word VBA | 4 | 07-18-2011 12:21 AM |
Fixing number or rows in a table | burnsie | Word | 2 | 07-12-2011 02:59 AM |
Repeating table rows in template? | TheWedgie | Word | 0 | 09-11-2010 09:35 PM |
Help Autoformating a Table w 2 header rows | Julie713 | Word Tables | 0 | 03-01-2010 08:15 AM |