J
jjfeenix
I have a Word 2003 doc containing a parent table with 24 nested tables in it.
Each of the 24 nested tables start out the same. Each nested table contains 2
dropdown combo boxes. Selecting from the first list, populates the second
dropdown combo. Selecting from the 2nd list populates certain cells. Certain
cells also contain form fields for collecting text while the document is
"lock/protected".
I want the users to be able to move the nested tables to other positions in
the parent table. I have a command button in a cell on each nested table that
unlocks the doc, selects the table and allows the user to grab the table
"handle" to move to another cell in the parent table.
The big problem is that the combo box item lists are "disconnected" when the
table moves. The last selected value is persistent, so repopulating the list
isn't a total problem...just a pain. Each nested table contains a bookmark in
the first cell to help me find it when/if necessary (ex.: Table01 thru
Table24)
First, why does this happen? Maybe I'm doing something wrong? (The lists
also disappear when you cut and paste tables.) Should moving the nested
tables be easier?
Second, I do a lot of color changes to cell text, background colors and
combobox.backcolors when a list selection is made. Would turning
screenupdating off at the top of the combobox_change sub, and back on at the
end, help "combine" all the different redrawing?
TIA
Each of the 24 nested tables start out the same. Each nested table contains 2
dropdown combo boxes. Selecting from the first list, populates the second
dropdown combo. Selecting from the 2nd list populates certain cells. Certain
cells also contain form fields for collecting text while the document is
"lock/protected".
I want the users to be able to move the nested tables to other positions in
the parent table. I have a command button in a cell on each nested table that
unlocks the doc, selects the table and allows the user to grab the table
"handle" to move to another cell in the parent table.
The big problem is that the combo box item lists are "disconnected" when the
table moves. The last selected value is persistent, so repopulating the list
isn't a total problem...just a pain. Each nested table contains a bookmark in
the first cell to help me find it when/if necessary (ex.: Table01 thru
Table24)
First, why does this happen? Maybe I'm doing something wrong? (The lists
also disappear when you cut and paste tables.) Should moving the nested
tables be easier?
Second, I do a lot of color changes to cell text, background colors and
combobox.backcolors when a list selection is made. Would turning
screenupdating off at the top of the combobox_change sub, and back on at the
end, help "combine" all the different redrawing?
TIA