Thread: command button
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default command button

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.