Excel macro

May 27, 2011
Reaction score
I have few questions concerning excel macro vba programming...

1- How can i clear all the text in checkboxes ?? for example i have like 20 checkboxes with "Check box" as text ... I want to only show the square of the checkbox without having any text...i found a way :
Dim clear As Shape
For Each clear In ActiveSheet.Shapes
clear.TextFrame.Characters.Caption = ""

With the for i=0 to 20 of course but this removes the text of the buttons i have too in the sheet....i only want it for checkbox or maybe for the checkboxes in 1 row only....
I even tried :
ActiveSheet.Shapes("Check Box i").Select
Selection.Characters.Text = ""
but i dont want it for 1 checkbox only....im lost
any idea??

Thank u!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question