Office for Mac - Macro to change checkbox cell number

Joined
Feb 19, 2013
Messages
2
Reaction score
0
Hey there,

I have about 300 checkboxes that I had to copy and paste down one column in an Excel spreadsheet. The problem is that I have to right-click on each one and choose "format control" to re-point each one to the cell it's in. Does anyone know how I can switch them all so that they're all pointing to the cell they're occupying without doing it manually on each one?
 
  1. Select the cell or cell range to copy and choose Edit→Copy.
  2. Click in the cell where you want to paste and then choose Edit→Paste Special.
  3. In the Paste section of the dialog, select the option that you need.
  4. Click OK.
2vhwt1c.jpg
 
Last edited:
I actually just cleared all of them, then made one checkbox but then went into the "format control" and cleared the cell information. Then I copied and pasted it about 10 times and then did a whole select so I was getting a much larger number each time. Then each one didn't have any cell data attached.

This works but the true/false doesn't. That didn't matter to me anyway, but so people know...
 
Back
Top