Assigning Different Caption to a Check Box

[Ed]

How do I use VBA to assign a different caption name to a
check box?

 

[GJones]

Ed;

You cannot dynamically change the caption for a check
box. What you could do is to leave the caption blank and
use more than one label and then make the correct one
visible and the rest not visible.

Thanks,

Greg

 

[Chip Pearson]

Ed,

Are this a check box on a userform? If so, use

Userform1.Checkbox1.Caption = "New Caption"

If the check box is on a worksheet, and comes from the Controls
command bar, use

Worksheets("Sheet1").OLEObjects("CheckBox1").Object.Caption =
"New Caption"

If the checkbox is on a worksheet, and comes from the Forms
command bar, use

Worksheets("Sheet1").CheckBoxes(1).Caption = "New Text"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Thanks. Can I hide and show the check box using VB?

 

[Ed]

Awesome! Thanks.

-----Original Message-----
Ed,

Are this a check box on a userform? If so, use

Userform1.Checkbox1.Caption = "New Caption"

If the check box is on a worksheet, and comes from the Controls
command bar, use

Worksheets("Sheet1").OLEObjects ("CheckBox1").Object.Caption =
"New Caption"

If the checkbox is on a worksheet, and comes from the Forms
command bar, use

Worksheets("Sheet1").CheckBoxes(1).Caption = "New Text"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com







.

 

[Tom Ogilvy]

What makes you think you can't programmatically change the caption of a
checkbox. That just isn't true.