C
cmpcwil2
I am new to VBA so just finding my feet, can anyone help me with th
differences between an excel control (i.e. one from the form toolbox
lets say a checkBox and a vba checkBox?
From trying the two controls the I have noticed is that you canno
capture the change event of the VBA checkbox in the code module, it ha
to be done via the sheet (i.e. checkbox on sheet1, code goes in chang
event on sheet1) the control is placed on, is this correct? What woul
you do if you have three sheets with the same controls just differen
data, do you really have to code the control 3 times?
The excel control however you can code a module to capture the chang
event but cannot reference the checkbox directly as i
activesheet.checkbox1.value, is this correct?
I am trying to decide which is the best 'toolbox' to use for a vba app
trying to ensure the code is not tied to a specific sheet. Not sure i
this is possible using these controls
differences between an excel control (i.e. one from the form toolbox
lets say a checkBox and a vba checkBox?
From trying the two controls the I have noticed is that you canno
capture the change event of the VBA checkbox in the code module, it ha
to be done via the sheet (i.e. checkbox on sheet1, code goes in chang
event on sheet1) the control is placed on, is this correct? What woul
you do if you have three sheets with the same controls just differen
data, do you really have to code the control 3 times?
The excel control however you can code a module to capture the chang
event but cannot reference the checkbox directly as i
activesheet.checkbox1.value, is this correct?
I am trying to decide which is the best 'toolbox' to use for a vba app
trying to ensure the code is not tied to a specific sheet. Not sure i
this is possible using these controls