Thread: CheckBox Q
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default CheckBox Q

Think I worked this, you have to exit the design mode before actually
you can 'tick' the box!! I thought you had to enter TRUE or FALSE in a
linked cell

Think then this formula (ex Ron Rosenfield) will count the TRUE
checkboxes =--OR(NOT(ISERR(SEARCH("TRUE",CONCATENATE(N14,N16)))) )