Expanding tables with calculating form fields?

macropod · #1 12-20-2016, 10:23 PM

Unless you only ever want to modify row 3 in table 2, you really should be using

.Tables(lTbl).Cell(lRow, 2).Range
That's because lTbl tells Word which table to modify and lRow tells Word which row in that table you're working with. If you're working on table 2, that's what lRow will contain and, if you're working on row 3, that's what lRow will contain. Note that it's lRow, not Row.

Update attached with Table 9b now incorporated

Father · #2 12-21-2016, 12:06 PM

Quote:

Originally Posted by macropod

Unless you only ever want to modify row 3 in table 2, you really should be using
.Tables(lTbl).Cell(lRow, 2).Range
That's because lTbl tells Word which table to modify and lRow tells Word which row in that table you're working with. If you're working on table 2, that's what lRow will contain and, if you're working on row 3, that's what lRow will contain. Note that it's lRow, not Row.

I'd attach an update with Table 9b now incorporated, but the forum software isn't cooperating right now...

Is lRow and lTbl the "address" for that specific table or any table?

I have additional pages for this form that have separate tables. If I wanted to do this in those how do I identify that specific table?

Father · #3 12-22-2016, 07:46 PM

Quote:

Originally Posted by macropod

Unless you only ever want to modify row 3 in table 2, you really should be using
.Tables(lTbl).Cell(lRow, 2).Range
That's because lTbl tells Word which table to modify and lRow tells Word which row in that table you're working with. If you're working on table 2, that's what lRow will contain and, if you're working on row 3, that's what lRow will contain. Note that it's lRow, not Row.

I'm attaching an updated version.
Disregard the content control parts.

2 issues

(1) In the macro I added OtherLocation for try to get block 4. dropdown option "Other" to behave like the dropdowns for 9a and 9b.

When I try to run this I get a compile error / syntax error.
It highlights With .Tables(lTbl).Cell(lRow, 3).Range.FormFields(1). I assume this means that either the table, cell, and/or row are not the right one(s) or do I need a different GetTblRow macro to run OtherLocation?

This is why I was asking about how to identify the table, row, and cell.

(2) When you use the "other" option that allows you to enter an additional choice it moves the "other" option in the dropdown from the top to the bottom. If you create 6 additional rows all using the "other" option it pushes the "other" option out of the menu altogether. Is there a way to keep "other" at the top of the drop down so it doesn't get pushed out? I left the additional rows created in place so you can see what I'm referring to.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to keep formatted form fields after mail merge or replace text with formatted form fields	jer85	Word VBA	2	04-05-2015 10:00 PM
Tables with form fields	step10	Word	18	11-12-2013 02:27 PM
Enable editing in expanding fields	marweste	Word	11	10-21-2013 07:41 AM
How to prevent Tables from expanding	HappyFingers	Word	1	11-29-2010 01:54 PM
Calculating Form Fields in Microsoft Word	wubba80	Word	1	06-25-2010 12:42 AM