Hi,
Can anyone tell me why there's no friggin' tag property
with the command button in Excel even though it's listed
in help?! Is there any way to store extra info with a
command button in Excel??

George R.

Both the forms controls and the ActiveX controls you use on the worksheet do
not have the tag property. It is only present when used on a user form.
Not sure of the reason why as my thought would also be that an ActiveX
control would expose all of it's properties, the tag being one of them.
Unless of course the ActiveX buttons used on the Worksheet are somehow
different from the ones used on the forms.

Never thought about this till this post. Anyway bottom line is tag is out
for storage when used on a form. I would put data in a named cell
underneath the commandbutton on the worksheet.

--
Regards,


Bill Lunney
www.billlunney.com

"George" wrote in message
...
Hi,
Can anyone tell me why there's no friggin' tag property
with the command button in Excel even though it's listed
in help?! Is there any way to store extra info with a
command button in Excel??

George R.

The activeX controls themselves do not have a tag property. They inherit it
from the container object (the control object on a userform). In a
worksheet they are contained in an OleObject which does not have a TAG
property.

--
Regards,
Tom Ogilvy

"Bill Lunney" wrote in message
...
Both the forms controls and the ActiveX controls you use on the worksheet
do
not have the tag property. It is only present when used on a user form.
Not sure of the reason why as my thought would also be that an ActiveX
control would expose all of it's properties, the tag being one of them.
Unless of course the ActiveX buttons used on the Worksheet are somehow
different from the ones used on the forms.

Never thought about this till this post. Anyway bottom line is tag is out
for storage when used on a form. I would put data in a named cell
underneath the commandbutton on the worksheet.

--
Regards,


Bill Lunney
www.billlunney.com

"George" wrote in message
...
Hi,
Can anyone tell me why there's no friggin' tag property
with the command button in Excel even though it's listed
in help?! Is there any way to store extra info with a
command button in Excel??

George R.

Cheers for clearing that up. Never knew how it worked.


--
Regards,


Bill Lunney
www.billlunney.com

"Tom Ogilvy" wrote in message
...
The activeX controls themselves do not have a tag property. They inherit
it
from the container object (the control object on a userform). In a
worksheet they are contained in an OleObject which does not have a TAG
property.

--
Regards,
Tom Ogilvy

"Bill Lunney" wrote in message
...
Both the forms controls and the ActiveX controls you use on the
worksheet
do
not have the tag property. It is only present when used on a user form.
Not sure of the reason why as my thought would also be that an ActiveX
control would expose all of it's properties, the tag being one of them.
Unless of course the ActiveX buttons used on the Worksheet are somehow
different from the ones used on the forms.

Never thought about this till this post. Anyway bottom line is tag is
out
for storage when used on a form. I would put data in a named cell
underneath the commandbutton on the worksheet.

--
Regards,


Bill Lunney
www.billlunney.com

"George" wrote in message
...
Hi,
Can anyone tell me why there's no friggin' tag property
with the command button in Excel even though it's listed
in help?! Is there any way to store extra info with a
command button in Excel??

George R.