Command for checking a checkbox in VBA?

[gumercindo]

Hi, simple question that I couldn't seem to find the answer for using the search command. I have a worksheet with a series of checkboxes. I'd like to run a macro that would check SOME of them and then uncheck them.

I tried recording the macro first, but the recording did not recognize me checking the checkbox. I also tried writing a VBA script that would add a space (" ") to that checkbox and that seemed to work but not optimal for adding the check makrs back in.

Any ideas?

Thanks!

btw, it's a form checkbox.

 

[Evagrius Ponticus]

you can simply set the value property of the checkbox to TRUE/FALSE

 Me.CheckBox1.Value = True

 

[Evagrius Ponticus]

In that case you can just link it to a cell and use the cell value (1 or 0) to check or uncheck the box.

 

[gumercindo]

you can simply set the value property of the checkbox to TRUE/FALSE

 Me.CheckBox1.Value = True

thanks. Can you be more specific - what does the "Me" mean?

In that case you can just link it to a cell and use the cell value (1 or 0) to check or uncheck the box.

I tried this and while the "0" unchecked them correctly, entering the "1" put the check back in but the value did not return. I think the first way would work best, just need to understand what the complete VBA code is.

Thakns!

 

[Evagrius Ponticus]

Hi - This is from the help file - it will explain Me far better than I can. You don't have to use Me though, you can just refer to the respective checkbox by its index number, i.e. checkbox1.value = this or checkbox2.value = that. You can also asign a variable(i) to the index number of the checkbox to cycle through all of your checkboxes.



The Me keyword behaves like an implicitly declared variable. It is automatically available to every procedure in a class module. When a class can have more than one instance, Me provides a way to refer to the specific instance of the class where the code is executing. Using Me is particularly useful for passing information about the currently executing instance of a class to a procedure in another module. For example, suppose you have the following procedure in a module:

Sub ChangeFormColor(FormName As Form)
FormName.BackColor = RGB(Rnd * 256, Rnd * 256, Rnd * 256)
End Sub

You can call this procedure and pass the current instance of the Form class as an argument using the following statement:

ChangeFormColor Me

 

[gumercindo]

Thanks, Tiger.

I opted for the checkbox17.value=False route, but I am still having difficulties.

Here's my code...

Sub xx ()

Sheets("worksheet1").Select
Checkbox17.Value = False

End sub

Am I missing something?

 

[gumercindo]

any suggestions before this falls off the first page for the night?

 

[Evagrius Ponticus]

Hey Gumercindo - can you tell us exactly what you would like to do and maybe we can work on the complete code? This code works for me.

Private Sub CheckBox1_Click()

Sheet1.CheckBox1.Value = False

End Sub

 

[RoryA]

If it's a Forms checkbox, you can use:

Sheets("worksheet1").Checkboxes("Checkbox17").Value = False

using the relevant name.

 

[Evagrius Ponticus]

Ha, nice Rorya - I didn't know you could do it that way