![]() |
|
|
|
#1
|
||||
|
||||
|
To work with multiple content control checkboxes, you might use code like: Code:
Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean) Dim StrNm As String Select Case CCtrl.Title Case "Check1": StrNm = "C:\Temp\MyWorkbook1.xls" Case "Check2": StrNm = "C:\Temp\MyWorkbook2.xls" Case "Check3": StrNm = "C:\Temp\MyWorkbook3.xls" Case "Check4": StrNm = "C:\Temp\MyWorkbook4.xls" Case Else: Exit Sub End Select Dim xlApp As New Excel.Application With xlApp .Visible = True .Workbooks.Open (StrNm) .Activate End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
| Tags |
| checkbox, content control, vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Export Word Drop-Down Content Control to Excel Specific Sheet
|
nolanthomas32 | Word VBA | 4 | 09-19-2017 06:25 AM |
Populate Content Control Dropdowns from Excel
|
Deirdre Kelly | Word VBA | 23 | 09-07-2017 02:51 PM |
Content Control Checkboxes
|
wlcdo2 | Word VBA | 3 | 01-05-2017 05:52 PM |
Deleting a table from a content control -- preserving the content control
|
BrainSlugs83 | Word Tables | 8 | 11-14-2013 03:06 AM |
Assigning Values to content control checkboxes and calculating results
|
creative cathy | Word Tables | 13 | 10-07-2012 08:52 PM |