Hello all,
I tried to search for my answer already, and while there are quite a few posts, I had a hard time finding an answer. So here goes:
I have inserted some checkboxes into a worksheet using the Forms Toolbar. Since I am somewhat crazy about having things named so they can be easily referenced, I simply selected each (total of 8) of the checkboxes and renamed them using the Name Box (to the left of the formula viewer) in Excel. So, for example, I have now:
chbx_000
chbx_001
chbx_010
chbx_100
chbx_111
etc....
Let's say that these checkboxes are on a worksheet called: "Analytics". How do I reference the value of the checkbox (yes/no) in VBA? I don't want to link the checkbox to a cell if I don't have to.
I thought it would be just something like this:
sheets("Analytics").chbx_000.value
That didn't work. Any suggestions? Thank you in advance!
I tried to search for my answer already, and while there are quite a few posts, I had a hard time finding an answer. So here goes:
I have inserted some checkboxes into a worksheet using the Forms Toolbar. Since I am somewhat crazy about having things named so they can be easily referenced, I simply selected each (total of 8) of the checkboxes and renamed them using the Name Box (to the left of the formula viewer) in Excel. So, for example, I have now:
chbx_000
chbx_001
chbx_010
chbx_100
chbx_111
etc....
Let's say that these checkboxes are on a worksheet called: "Analytics". How do I reference the value of the checkbox (yes/no) in VBA? I don't want to link the checkbox to a cell if I don't have to.
I thought it would be just something like this:
sheets("Analytics").chbx_000.value
That didn't work. Any suggestions? Thank you in advance!