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?


.