John,

I assume you are using the Command Buttons from the Controls toolbar, not
the Forms toolbar. Given that, you can change the Caption property of the
button to the new text. E,g.,

Sheet1.CommandButton1.Caption = "New Text"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John Baker" wrote in message
...

Hi

I am afraid I have been asking a lot of questions here as I develop my
application. I hope
the results are useful to others too.

I have push buttons on my spreadsheet, and would very much like to be able
to change the
name on them as conditions on the spreadsheet change. For example, we have
some fields and
functions that are linked to the month and day (a variable based on other
conditions). I
would like to be able to change button text so that the month and day that
appear on the
button (although the actual macro linked to the button will not change).
The data I would
like to show in the button resides in cells in the spreadsheet, and is
being used for
other things as well.

My problem is that when I edit the button contents, all I get it the hard
data I enter.
Playing around with the name in properties does not get me far either. I
don't even know
if there is a way to do it, but if there is can someone share it with me
please?

Regards

John Baker