View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel[_18_] Daniel[_18_] is offline
external usenet poster
 
Posts: 19
Default question on VBA and Checkboxes - Newbie

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