View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ephraim Ephraim is offline
external usenet poster
 
Posts: 15
Default Checkbox - Output results to a csv file

Hi,

I have a small spreadsheet with 20 check boxes in Column A (A1-A20).
They are all linked to corresponding cells in Column B which give TRUE
or FALSE depending on if they are checked or unchecked. No problem
there.

I have the corresponding check boxes displaying "Computer 1" in cell
C1 and so on down to C20
i.e. Formula in C1 is =IF(B1,"Computer 1","")

Once the user has checked/unchecked as required then I'd like to be
able to save Column C1:C20 and Column D1:D20 to a csv file called
"UserInput.csv"

Thanks
Ephraim