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

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


-----Original Message-----
How do I use VBA to assign a different caption name to a
check box?
.

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").Objec t.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




"Ed" wrote in message
...
How do I use VBA to assign a different caption name to a
check box?

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

-----Original Message-----
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


-----Original Message-----
How do I use VBA to assign a different caption name to
a
check box?
.

.

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




"Ed" wrote in
message
...
How do I use VBA to assign a different caption name to
a
check box?


.

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

--
Regards,
Tom Ogilvy

GJones wrote in message
...
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


-----Original Message-----
How do I use VBA to assign a different caption name to a
check box?
.