Thread: How to create a Macro to Name a Checkbox
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Stasio Stasio is offline
external usenet poster
  
Posts: 3
Default How to create a Macro to Name a Checkbox
Tom,
i figured out what I was doing wrong. I had to modify your example of:

activesheet.Optionbuttons(2).Name = "OptionButton8"

To:

ActiveSheet.CheckBox1.Caption = "OptionButton8"

Thank-you much for all of the assistance.


"Stasio" wrote:

Is there a way that I can create a macro to allow me to click a button within
a worksheet that will allow me specify a name for a checkbox?
Reply With QuoteReply With Quote