Excel: How can I insert the value of cell into ActiveX button caption?

kegobeer said:

No, he wants to dynamically change the label.

Ah, my bad. I think you are correct - VB is the way to do it.

Regards,
GEWB

FYI, I've found the code I needed. Simple as a matter of fact.

Under ThisWorkbook > Workbook, the code is:
Private Sub Workbook_Open()
ThisWorkbook.Worksheets("RAID_PRV").ClearWeek.Caption = "Clear week " & ThisWorkbook.Sheets("RAID_PRV").Range("OldestWeek")
End Sub

I'd like to thank everyone who wanted to help and spent the time doing so.
Peatawn