referencing a checkbox cell address in a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I was wondering if anyone knew how to referece the cell address of a
checkbox on a worksheet. I know it is possible with ActiveX checkboxes,
using the TopLeftCell property, but I need something similar for MSForm
objects. I have a macro that needs to lock the checkboxes from change if a
user has made a selection over them.

Thanks!
 
Demo'd from the immediate window:

set rng = ActiveSheet.Checkboxes("Check Box 1").TopLeftCell
? rng.Address
$H$6
 
Back
Top