That wouldn't be meaningful in code unless you just added the Checkbox.
Hard coding the name of the control in your code, at least to me, doesn't
make sense to perform that type of action. I have posted an alternative
method elsewhere in the thread.

--
Regards,
Tom Ogilvy


"Stasio" wrote:

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?