Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
detecting keypress(es) in a cell | Excel Programming | |||
detecting duplicate input in a cell | Excel Worksheet Functions | |||
Cell value - detecting change | Excel Worksheet Functions | |||
Detecting Numbers in a cell | Excel Worksheet Functions | |||
automatically detecting changes in a cell | Excel Discussion (Misc queries) |