Struggling to change the caption of a command button in excel (2007) using VBA? Try the following code:
Application.ActiveWorkbook.Sheets(Sheetname where button is located).Shapes(name of the button).DrawingObject.Object.Caption = “New Caption!”
Somehow in Excel 2007 using .Textframe.Characters.Text no longer seems to work. It gives you an “Object does not support this method” error message.