checkbox caption

I'm trying to set up a worksheet change event that creates a checkbox in column 1 if the cell in column 8 changes. I am able to get a checkbox, but I can't get the caption to change. I'm able to do it using this code, but I don't want to do it manually. Thank you in advance for any pointers...

Hello, I am trying to change checkboxes caption name using a loop so that I don't have to change them individually. Here is a simplified example of what want to do: 1) I save the caption names in a array 2) I run through a loop to rename each checkboxes using the names saved in the array...

Is there a way to insert a square box (used as whitespace) in a checkbox caption?

I am adding text in a caption checkbox: 1. How to add whitespace in a caption so that it will format and look like this. rather than 1. How to add whitespace in a caption so that it will format and look like this. When I enter spaces using the spacebar, it doesn't seem to...