Detecting a control in a cell?
 

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

Detecting a control in a cell?
 

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