Detecting a control in a cell?

[cmpcwil2]

You can find out the location of a control on a sheet e.g. control.topleftcell.address

But is it possible to find out if a cell has a control attached to it and then find out the control name? for both excel form contorls or contol toolbox or vb toolbox controls?

Any ideas??

[Dave Peterson]

I think you'll have to loop through the controls, then check that topleftcell
property to see if it's the cell you're interested in.

cmpcwil2 wrote:
>
> You can find out the location of a control on a sheet e.g.
> control.topleftcell.address
>
> But is it possible to find out if a cell has a control attached to it
> and then find out the control name? for both excel form contorls or
> contol toolbox or vb toolbox controls?
>
> Any ideas??
>
> --
> cmpcwil2
> ------------------------------------------------------------------------
> cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
> View this thread: http://www.excelforum.com/showthread...hreadid=535937

--

Dave Peterson