Delete rows in table if checkbox value in first cell equals true
in [Word VBA]
|
Prev: Detecting selection is in footnotes area
Next: Delete rows in table if checkbox value in first cell equals true
From: Mitch on 16 Dec 2009 20:18 Hi People, First time caller long time observer. I'm creating a form which contains three tables. First two tables contain information such as heading, date, time, user details etc. Table three consists of 2 rows and 5 columns. First row is used for column headings and second row contains form fields where the user can record their data. The first cell of row 2 contains a checkbox and the rest contain text fields. Now, I would like the user to have the ability to add and remove rows at click of a button. After couple hours of researching I figured out the code that will add another row including all the described form fields but I cannot figure out the deletion part. I'm looking for a script that will delete a row in the table based on the condition where checkbox in the targeted row = true (checked). So in the scenario where user wishes to delete certain rows in the table they can just tick the checkboxes in unwanted rows and press the button to delete. If working with checkboxes is difficult I can replace with automated numbers. Much appreciated in advance.
From: alborg on 19 Dec 2009 04:21
Hi Mitch: I have a free applet that other docs download to follow patients that has a delete row routine, called not by a click of a on-template button but by a menubutton. See http://i38.photobucket.com/albums/e103/alborgmd/Software/delhighlightedcells.png The applet (the "Charge Capture Utility") can be downloaded from here- http://www.msofficeemrproject.com/Page2.htm and of course is open-code. Once you get into the Visual Basic platform, go to any code window and look up "delete." Hope it'll help you... Al "Mitch" wrote: > Hi People, > > First time caller long time observer. > > I'm creating a form which contains three tables. First two tables contain > information such as heading, date, time, user details etc. > > Table three consists of 2 rows and 5 columns. First row is used for column > headings and second row contains form fields where the user can record their > data. The first cell of row 2 contains a checkbox and the rest contain text > fields. > > Now, I would like the user to have the ability to add and remove rows at > click of a button. After couple hours of researching I figured out the code > that will add another row including all the described form fields but I > cannot figure out the deletion part. I'm looking for a script that will > delete a row in the table based on the condition where checkbox in the > targeted row = true (checked). So in the scenario where user wishes to delete > certain rows in the table they can just tick the checkboxes in unwanted rows > and press the button to delete. > > If working with checkboxes is difficult I can replace with automated numbers. > > Much appreciated in advance. |