![]() |
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! |
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