Find the name of a button in a cell

[Foo_Man_Chu]

Hey All,

I'm using excel 2010. In the code in my macro that I'm working with, I want to be able to take a cell reference and determine if there is a button in that cell and if there is what the name of that button is. Any ideas?

Thanks in advance.

 

[pgc01]

Hi

What kind of button is it, a Forms button or an ActiveX button?

You can loop through the buttons in the worksheet and check the TopLeftCell against your cell.