Hi,
I am working with an electronic medical record (EMR) that is a very "dumb" program, having very few amenities. I want to create a Word Form to structure the way our clinicians document their care. They will open the Word form, input data which then gets copied and later pasted into the EMR.
I can create the form, no problem. Now I want to put in a "Copy All" button that will, well copy everything onto the clipboard to be pasted into the EMR. So the form would look like:
Blood Pressure ___ (Blood Pressure is the form label and the blank__ is the text box where the user inputs data)
Pulse ___
Temp. ___
Basically a simple series of labels with text boxes following them. I'd like the button to copy the label texts & Text box values and any carriage returns (other formatting doesn't matter as that won't paste into the EMR). I've worked all day on this and can get a few things copied but not all. Does anyone have some VBA code ideas?
Thanks, Chris
I am working with an electronic medical record (EMR) that is a very "dumb" program, having very few amenities. I want to create a Word Form to structure the way our clinicians document their care. They will open the Word form, input data which then gets copied and later pasted into the EMR.
I can create the form, no problem. Now I want to put in a "Copy All" button that will, well copy everything onto the clipboard to be pasted into the EMR. So the form would look like:
Blood Pressure ___ (Blood Pressure is the form label and the blank__ is the text box where the user inputs data)
Pulse ___
Temp. ___
Basically a simple series of labels with text boxes following them. I'd like the button to copy the label texts & Text box values and any carriage returns (other formatting doesn't matter as that won't paste into the EMR). I've worked all day on this and can get a few things copied but not all. Does anyone have some VBA code ideas?
Thanks, Chris
