Hello Dennis,
This is more involved that it first appears. This was a good question, and now you have a solution. This requires using the API to extract key information about the text so the ActiveX control (Control Toolbox) caption can be sized correctly using the control's width and the Font. Copy this macro into a VBA module. There is sample showing how to call the macro following the code.
Macro Example
The macro adds the text to CommandButton1 on Sheet2. The sheet name is optional. If you don't specify a name then the ActiveSheet is the default.
Sincerely,
Leith Ross
Bookmarks