Hi, in the Properties dialog for my CheckBox there is an item labelled "Caption" where I can enter any text and it becomes the caption for the checkbox.
Instead of entering text, I would like the text from a specific cell to populate the field for the Caption. For example, the text in cell "Rates!B11" would be the caption for the Checkbox. If a user changes the contents of cell B11 then the caption for the checkbox changes as well.
The checkbox resides on a form called "RentalForm". The following VBA code will temporarily change the caption, but it does not permanently change it as seen in the Properties Dialog.
RentalForm.Checkbox.Caption = Range("Rates!B11")
Bookmarks