Hi

Sure it seems to work.

Private Sub CommandButton1_Click()
Sheets(1).CommandButton1.Caption = Now
End Sub

HTH. Best wishes Harald

"Dr_Phil " skrev i melding
...
hi, how do you change the caption of a button from VBA code. The button
is on a sheet called XS003 if that helps......

from VB it is commandbutton1.caption = "blah blah blah"

but that dosnt seem to work

any help would be appreciated....

thanx


---
Message posted from http://www.ExcelForum.com/