How to get CheckBox name in a cell?

[shirazbj]

I put a CheckBox in a cell. How do I get its name with VBA?

Thanks

 

[shirazbj]

The CheckBox is added by:

View/ToolBars/Forms/Checkbox

or View/ToolBars/Control ToolBox

I think It is acturally in the sheet.

I added 10 checkboxes in a column. Maybe I should link the checkbox to a cell. When I click a checkbox, it could change the value of the linked cell from True to False. But I don't know by VBA, when I click a checkbox, which one I have clicked?

 

[Dathai]

Hi shiazbj,

You're right, the checkbox code is associated with the sheet in which you created it.
Open the VBE, in the Project Explorer, locate the sheet name (e.g. Sheet1 (Sheet1)) and double-click it to open the code window.

The left most drop-down of the code window probably shows "General" at the moment. Click this drop-down and you should see the names of all the checkboxes you have created. As you select each, the default CheckBox#_Click() event is created.

you can get the name of the clicked checkbox using something along the lines of:

Private Sub CheckBox1_Click()
worksheets("Sheet1").Range("B2") = CheckBox1.Caption
End Sub

Hope this helps.