Uncheck a Check Box using VBA

**ashmott** · 09-01-2011, 08:03 PM

Hi
I have a code which I am trying to use to uncheck a check box but keep getting the error "Unable to get the CheckBoxes property of Worksheet class"

Can anyone help?

Please Login or Register  to view this content.

**Kenneth Hobson** · 09-01-2011, 08:27 PM

Please Login or Register  to view this content.

**nickvans** · 09-01-2011, 08:28 PM

Try Sheets("Sheet1").CheckBoxes.Item("CheckBox1").Value = False

It looks like you left off the Item argument of the Checkboxes collection.

--Nickvans

**ashmott** · 09-01-2011, 08:35 PM

Thanks guys but im still getting an error.
I have attached my workbook if yoh have a chance to take a peek.
Sorry for beng a noob.

**Leith Ross** · 09-01-2011, 09:40 PM

Hello ashmott,

There were 2 problems with the code. One, the control being used is a Forms control.. You can not use False to uncheck a Forms control. You must use the Excel constant xlOff. Two, you had the control name wrong. It is "Check Box 1", not "CheckBox1". Here is the corrected and working code.

Please Login or Register  to view this content.

**ashmott** · 09-01-2011, 10:29 PM

Thanks for your help Leith, much appreciated.

Uncheck a Check Box using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Uncheck a Check Box using VBA

Re: Uncheck a Check Box using VBA

Re: Uncheck a Check Box using VBA

Re: Uncheck a Check Box using VBA

Re: Uncheck a Check Box using VBA

Re: Uncheck a Check Box using VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions