Tom,
Thanks for the quick response.

I was able to use this as long as I keep it as you have it stated with the
".Name".

I do need it to change for the caption though and when I change ".Name" to
".Caption" i receive a debug error code 438. It states: Object doesn't
support the property or method.


"Tom Ogilvy" wrote:

for control toolbox toolbar controls, you can use

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

for optionbuttons from the forms toolbar
activesheet.Optionbuttons(2).Name = "OptionButton8"

If you really meant the caption, then change Name to be Caption.

--
Regards,
Tom Ogilvy

"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?