how to process checkboxes in VBA

[jmac1947]

Hello,

I am stuck on a basic problem of trying to work out how to handle checkboxes in VBA

I have a worksheet ("Sheet1") with an activex checkbox (CheckBox1) in cell B1

what code do I need to tell if the checkbox is ticked or not. (it probably should be some true / false type test but I keep not getting the syntax of the code correct.

what do I need to declare or set or ????? to access the state of the checkbox please

Help appreciated


Jmac

[Leith Ross]

Hello jmac1947,

ActiveX controls are part of the OLE Objects collection for a worksheet.

Please Login or Register  to view this content.

[jmac1947]

Thanks Leith, assistance is appreciated.
would the code alter if I had a "forms" checkbox instead of an ActiveX one?

Jmac

[Leith Ross]

Hello jmac1947,

Yes, it would. The Forms controls are lighter weight controls created by Excel. ActiveX controls, also known as OLE (Object Linking and Embedding), conform to the Windows COM (Common Object Model) standard.

[jmac1947]

OK, thanks again Leith, help appreciated

[Leith Ross]

Hello jmac1947,

Did you need want to see code the Forms check boxes also?

[jmac1947]

Hi Leith,

if it isnt too much trouble, I will store it away in my "helpful snippets of code" repository

Thanks