![]() |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
creative cathy | Word Tables | 13 | 10-07-2012 08:52 PM |
![]() |
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 |