Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkboxes:linking with cells and sorting | Excel Discussion (Misc queries) | |||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS | Excel Discussion (Misc queries) | |||
checkboxes | Excel Worksheet Functions | |||
How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
Cells as checkboxes? | Excel Discussion (Misc queries) |