activesheet.buttons options

[Foo_Man_Chu]

Hi all,

I'm working with a button in my spreadsheet and have come up with a question.
If I use the following code:

msgbox(activesheet.buttons(application.caller).name)

I get a message box that pops up with the name of the button I just clicked.
The question I have is this: what other things (methods, properties, etc) are associated with the buttons object or array or whatever it is? I've searched online but I can't find anything. For example: say that I wanted to know the number of buttons on the current sheet. Is there something like:

msgbox(ubound(activesheet.buttons))

that I could use? The lack of documentation I have been able to find on this has been maddening.

Thanks in advance!

 

[shg]

From the Immediate window, enter

? ActiveSheet.Buttons.Count


Open the Object Browser (F2), right-click in one of the windows, and select Show hidden members. Then enter buttons in the search dialog to see properties and methods.

 

[Foo_Man_Chu]

Thank you SOOO much! That resource is exactly what I was looking for! Thank you, thank you, THANK YOU!!!

 

[shg]

You're welcome. And I agree with you abouit the scarcity of documentation.