View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Childs[_2_] Tim Childs[_2_] is offline
external usenet poster
 
Posts: 18
Default Checkboxes in cells

Hi

When extracting data from a web-based financial system, I copy a table of
data from a web page into Excel with tickboxes in one column, some of which
are checked and some not. These are some sort of image and occupy part of
one cell. How can I convert these images (based on whether checked or not)
into their binary digital equivalent "1" or "0", or alternatively TRUE or
FALSE.

In addition, I found that the checkboxes are not copied when cells are
copied to a new location. Also the cells containing the checkboxes are empty
in terms of cell text editing and I cannot "click onto" the image of the
checkbox when viewing the sheet.

Finally, when using macro record, the checkbox can be checked or unchecked
but the macro records nothing - why is that? Apols about being in "wrong" ng
for that question.

Any help gratefully received

Thanks

Tim