D
Daniel
Hi everybody,
I have this Excel worksheet which, to make it simple, has 10 lines and 20
columns.
I inserted a checkboxIn each cell of column 19 and column 20.
And now I would like to determine the value of all this checkboxes, checked
or not checked, by means of a VBA code.
Could someone put me on the right track ? What would the instructions look
like, to "scan" the 2 columns and return the value of each box ?
Do I have to declare all these checkboxes ? If so, how and where do I have
to do this in the sub ?
Many thanks in advance for your kind help.
With best regards,
Daniel
VBA newbie
I have this Excel worksheet which, to make it simple, has 10 lines and 20
columns.
I inserted a checkboxIn each cell of column 19 and column 20.
And now I would like to determine the value of all this checkboxes, checked
or not checked, by means of a VBA code.
Could someone put me on the right track ? What would the instructions look
like, to "scan" the 2 columns and return the value of each box ?
Do I have to declare all these checkboxes ? If so, how and where do I have
to do this in the sub ?
Many thanks in advance for your kind help.
With best regards,
Daniel
VBA newbie