Hi, I've attached a file I was working on. Can someone help me with a problem I am trying to solve? If you will look at the document, I have SBAR rows for each area. What I am trying to do is on row A to have an option to insert another set of SBAR rows. I'd like this to be an option to whoever is typing on the document, if he/she doesn't want to add the extra SBAR it wouldn't be there. But there would be an option to insert an extra set under row A. Is that even possible??

Attached Files

DM.docx (32.4 KB, 7 views)

Yes, that's quite possible, but you'll need to use a macro, which means saving the file in the docm format. Try the attached, which has all the code in place. You'll be prompted as to whether to add a new set whenever you click in the last content control in the table.

Attached Files

DM.docm (61.4 KB, 17 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for that. But it looked just the same as the original one only saved as macro enabled. Which part does the user click on? Sorry really new to this and literally clueless. I've edited some rows it should look like this.

Attached Files

DM.docm (54.9 KB, 9 views)

You click on the last content control in the table (i.e. the one below the 'Total patients' heading).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks! That was awesome! But is there a way to insert a set of SBAR rows in a specific "row A" of one area? For example, I want to insert a full set inside the "row A" of CTU. Is that possible? to place a command button on all the cells to the left of 'A rows' to insert a full set of SBAR rows inside that cell?

Yes, but that's a whole lot more complicated with your table structure. It would be much easier if you had a separate physical table for each SBAR group, though, in which case the content control for each such group could be used to trigger the prompt.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks sooo much! Do you mean like this attached file? If anyone could help me coding this, it would be great! As you could tell, I'm in healthcare and is clueless with these kinds of stuff. Thanks again for your input!!!

Attached Files

DM.docm (29.1 KB, 8 views)

Try the attached. If you want to see what drives the process, press Alt-F11 and look in the document's 'This Document' code module. Press Alt-F11 when you're done. The code is already written so that, if you apply editing restrictions to the document (so as to guard against unauthorised changes to the form) and password-protect them, all you'll need to do is add the password to the code.

Attached Files

DM-2.docm (57.3 KB, 16 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

You are amazing, Paul!!!! Thank you very much! I know it might be too much to ask, is there a way that the columns to the left (Area/Patients) do not double up when the user choose Yes? Thanks!

You are amazing, Paul!!!! Thank you very much! I know it might be too much to ask, is there a way that the columns to the left (Area/Patients) do not double up when the user choose Yes? Thanks!

Try the attached. I've re-arranged the tables slightly to make the row additions simpler.

Attached Files

DM-3.docm (59.5 KB, 15 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

You're a legend Paul! Problem solved!!!!

Is it possible to have the extra BAR set in this file to have outside borders as the one shown in ICU area? Thanks!

I just wanted the new BAR sets to be partitioned from the BAR set above it. So just a top border above the B row. Thanks in advance! and pardon my ignorance.

Attached Files

DM Report4.docm (447.7 KB, 11 views)

Try the attached. I had to delete the logo to keep within the board's upload size limit.

Attached Files

DM-4.docm (56.7 KB, 17 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]