excel source for Word combo box

mdkusername

New Member
Joined
Dec 9, 2015
Messages
34
I am trying to use Excel tables as the source for Word combo box. I have tried a variety of code but am unsuccessful.
For a Word document I will have combo boxes, and having Excel as the source increases the choices available to choose from.
excel example.xlsx
ABCDEFG
1Access typeColumn1ProcedureClosure
2Right brachial artery to basilic vein arterio-venous graft (36830)SideA subcutaneous tunnel was then marked on the skin and was infiltrated with 1% lidocaine with epinephrine. Using a tunneler, a 4mm x 7mm PTFE graft was positioned in a subcutaneous space with the 4mm end at the brachial artery and the 7mm end at the vein. The patient received heparin 5000 units IV.The patient was given protamine sulfate to reverse the heparin, and hemostasis was obtained. The wound closed with 2-0 Vicryl in a running fashion for the subcutaneous tissue, and 4-0 Monocryl for subcuticular skin approximation. The wound was dressed with skin glue. The patient was transferred to PACU in a stable condition.
3Left brachial artery to cephalic vein arteriovenous fistula (36821)RightA subcutaneous tunnel was then marked on the skin and was infiltrated with 1% lidocaine with epinephrine. Using a tunneler, 6mm PTFE graft was positioned in a subcutaneous space. The patient received heparin 5000 units IV.The patient was given protamine sulfate to reverse the heparin, and hemostasis was obtained. The wound closed with 2-0 Vicryl in a running fashion for the subcutaneous tissue, and 4-0 Nylon for a running skin approximation. The wound was dressed with aseptically. The patient was transferred to PACU in a stable condition.
4Right brachial artery to cephalic vein arteriovenous fistula (36821)Left
5Left brachial artery to antecubital vein arteriovenous fistula (36821)
6Right brachial artery to antecubital vein arteriovenous fistula (36821)
7Left radial artery to cephalic vein arteriovenous fistula (36821)
8Right radial artery to cephalic vein arteriovenous fistula (36821)
9Right brachial artery to basilic vein arterio-venous graft (36830)
10Left brachial artery to basilic vein arterio-venous graft (36830)
11
12
Sheet1
 

Attachments

  • Screenshot (25).png
    Screenshot (25).png
    215.9 KB · Views: 13

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,223,997
Messages
6,175,874
Members
452,679
Latest member
darryl47nopra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top