New
#1
Excel: How can I insert the value of cell into ActiveX button caption?
Hi,
I'm using Office 2007 and I have an Excel file that I have to update often. Therefore I will automate certain tasks using macros accessible by ActiveX Control command buttons. However, I would like for the captions to be relative to information found in certain cells; examples of a caption I would like to have:
• "Clear week [value of cell A5]"
• "Last reporting day for week [value in cell named "_OldestWeek"]".
This will help any other colleague using the spreadsheet not to get confused with the actions of each button.
Is there a way to do this?
Thanks in advance for any help,
Peatawn