mardi 4 décembre 2018

Excel - Copy True/False Values in Checkboxes to Another Workbook

I am trying work how to copy the contents of checkboxes (ie the TRUE/FALSE part) into another workbook. This is part of a macro to copy several different values and put in a summary table.

What I am trying to find out is:

  1. How to select the checkbox in the source spreadsheets
  2. How to put the value (TRUE/FALSE) in the destination spreadsheet.

The other values are being copied across in the loop that looks at all the spreadsheets in a selected folder, for example:

 'Define where the source data is located in DP Calculator
    Set SourceRangeID = WorkBk.Worksheets("Calculator").Range("B12")     

 'Set the destination ranges in Summary Sheet
    Set DestRangeID = WksSummary.Range("b" & NRow)

 'Copy over the values from the source to Summary Sheet
    DestRangeID.Value = SourceRangeID.Value

There are a number of lines like these defining each source and destination range.

Ideally the copying of the checkbox will slot into these lines.

Thank you very much




Aucun commentaire:

Enregistrer un commentaire