ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   referencing a checkbox cell address in a worksheet (https://www.excelbanter.com/excel-programming/333023-referencing-checkbox-cell-address-worksheet.html)

Erik Andreassen[_2_]

referencing a checkbox cell address in a worksheet
 
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!

Tom Ogilvy

referencing a checkbox cell address in a worksheet
 
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!





All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com