Can you connect Form Controls to a cell reference?

[brendan_mckenzie]

Hello,

When entering a form control like a checkbox into a spread sheet, is there a way to get the cell reference for where it is. For example if I put a check box inside cell B4, is there a way to pick up its location in its macro?

This in on excel 2013

Thanks,

 

[RoryA]

Welcome to the forum.

You can use:

[code)Activesheet.Shapes(Application.Caller).Topleftcell[/code]

to get the cell under the top left corner of the control you clicked.