Return Index of Control Object Clicked!
Hi,
How do i return the Index of the Checkbox (control ToolBox item, not Forms
toolbar item) embedded on a worksheet (sheet1) on CLICKING it. Please note
that there are many checkboxes embedded on the worksheet.
I Dont want (something as shown below) to create seperate code for each
Checkbox as there are around 250 Checkboxes on the Sheet1.
Private Sub CheckBox2_Click()
End Sub
Private Sub CheckBox2_Click()
End Sub
Private Sub CheckBox2_Click()
End Sub
................but one code which will run for every clicked checkbox on the
worksheet. thats why the need for refering index of checkbox.
What i want to do is:
Once the Checkbox is clicked, it should change its Caption Property to show
system-Time (Now), Linked cell property - linked to a similar cell (say,
Checkbox1 placed on cell A5 on Sheet1, so Linked Cell will be Sheet2!A5) on
Sheet2.
How do i do this using VBA?
Eijaz
|