View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ronnie Ronnie is offline
external usenet poster
 
Posts: 53
Default checkbox value read out

How can I convert a checked checkbox into value "1" ? I created a checkbox
(via toolbar-Form) in a cell. When I copy and special paste link that cell
to another sheet in the workbook, the value is "0" even when I check the
checkbox. What I want is to see an "1" when the checkbox was checked. I need
the bolean value to be imported in MS Access.