Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to use a CommnadButton on a form to Select ALL Checkboxes on a
form IF the CheckBox Caption is NOT "----------". However i keep getting a error on the below identified line, why ? Private Sub CommandButton2_Click() Dim chx As CheckBox With UserForm6 If chx.Caption < "----------" Then '<==== ERROR For Each chx In UserForm6 chx.box = True Next chx End If End With End Sub How can i fix this? Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to clear all checkboxes on a form? | Excel Worksheet Functions | |||
uncheck checkboxes from a form | Excel Programming | |||
Adding Checkboxes to a Form | Excel Programming | |||
Selecting many Checkboxes to align & size | Excel Programming | |||
selecting values form multiple excel files into an excel worksheet | Excel Programming |