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.