ActiveX Label

[Daxton A.]

i am running Excel 2010 with a "Clear" button. The clear button works well for removing all the text but now I am wanting the checkboxes to be unchecked. My friend needed an ActiveX label inserted instead of a checkbox and the only place it is vba accessible is inside the Worksheet_Change Module. I had to set the font = wingdings and set the character equal to Alt + 0252 so it will give me a check mark. Every time I try to run a "clear" macro, it throws me an error message: Run-time error '438' --- Object doesn't support this property or method.

My brain feels like it is hamburger meat! Lol
Thanks

[p45cal]

ActiveSheet.Label1.Caption = Chr(252)

[Daxton A.]

Wow, that was easier than I thought! Thank you! I figured the ActiveX shape was only accessible in the Worksheet VBA. Again thx! :rofl:

Solved!