Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Selecting multiple Checkboxes on a form
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Selecting multiple Checkboxes on a form
Hi Corey,
If you want to use the variable instead of the checkbox name you need to assign a checkbox to it first otherwise how does it know which checkbox caption you are referring to. Because you are using chx in the For Each loop, perhaps simply using the actual name of the checkbox to identify the caption. -- Regards, OssieMac "Corey ...." wrote: 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.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Selecting multiple Checkboxes on a form
Adding to Ossie's observation, moving your If statement inside the For ...
Next loop will accomplish the variable assignment through the For Each chx part of the statement. Then you will need to fix the statembent: chx.box = True Looks like it should be just: chx = True "Corey ...." wrote: 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.... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Selecting multiple Checkboxes on a form
You also need to modify this line:
For Each chx In UserForm6 To: For Each chx In UserForm6.Controls This assumes you only have checkboxes on the form. "Corey ...." wrote: 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.... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Selecting multiple Checkboxes on a form
One more adjustment. To get the checkmark to show:
chx.Value = True "Corey ...." wrote: 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.... |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Selecting multiple Checkboxes on a form
Option Explicit
Private Sub CommandButton2_Click() Dim ctrl As control 'msforms.CheckBox for each ctrl in me.controls if typeof ctrl is msforms.checkbox then if ctrl.caption = "----------" then 'do nothing else ctrl.value = true end if end if next ctrl End Sub "Corey ...." wrote: 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.... -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Selecting multiple Checkboxes on a form
Thank you guys.
Got it working now. Now for the next issue/topic? "Corey ...." wrote in message ... 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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |