Rename Macro Caption

[aaronz07]

Hi,

Please help with the below:

I need to create a macro in VBA that will need to rename the caption

eg. commandbutton1.caption = commanbutton2.caption

My problem is that how do I retain the caption change. I when I close the workbook I want the caption to stay the same. The buttons is on the form.

Thanks.

 

[Gary McMaster]

Hi Aaron,

You will have to save that text somewhere. Where depends on whether or not the workbook will be saved and what your preferences are.

If it will be saved:

In a cell (possibly hidden: row, column, worksheet)
In custom properties
Write to a text file
Write to the registry (machine specific)
(possibly other options)

If it will not be saved:

Write to a text file
Write to the registry (machine specific)

In any case, the saving of the text string could be done in the workbook "Close" event if not as soon as the caption changes.

Gary