Thread: Assigning Different Caption to a Check Box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Assigning Different Caption 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?


Reply With QuoteReply With Quote