![]() |
|
#10
|
|||
|
|||
|
Code:
Private Sub CommandButton1_Click()
Dim oCtr As Control
Dim strComposite As String
For Each oCtr In Me.Controls
Select Case TypeName(oCtr)
Case "CheckBox"
If oCtr.Value = True Then
If strComposite = vbNullString Then
strComposite = oCtr.Name & " is checked"
Else
strComposite = strComposite & ", " & oCtr.Name & " is checked"
End If
End If
End Select
Next oCtr
'Replace this statement with code that writes the string variable to your bookmark.
MsgBox strComposite
End Sub
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Generate chart from list of text values
|
knownunknown | Excel | 6 | 04-24-2013 01:56 AM |
| Check box and text box in same document ? cant edit / enter text | KennyG | Word | 6 | 04-08-2013 10:59 AM |
Assigning Values to content control checkboxes and calculating results
|
creative cathy | Word Tables | 13 | 10-07-2012 08:52 PM |
Handle Text / Numeric values in SSRS while Export To Excel
|
achuki | Excel | 5 | 02-07-2012 02:14 PM |
| How Do I Put Text Values Into A CSV That Excel Will Leave Along? | eBob.com | Excel | 2 | 05-04-2011 07:01 AM |