Detecting a control in a cell?

  • Thread starter Thread starter cmpcwil2
  • Start date Start date
C

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??
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programable Controls on a Chart 2
control toolbox vs forms toolbars 2
Excel 2010 Charting in Userform - Can't Access OWC11 Control from Toolbox?? 5
forms toolbar vs. control toolbox 1
combobox 2
Detect Option Group Value in VBA 2
How to add Checkedlistbox Control to VBA? 1
Problem with FTP commands in Win7+Excel2010 (VBA) 5

Back
Top