Demo'd from the immediate window:

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

--
Regards,
Tom Ogilvy


"Erik Andreassen" wrote in
message ...
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!