ExcelBanter - Changing Text in a Forms Button

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Changing Text in a Forms Button (https://www.excelbanter.com/excel-programming/323152-changing-text-forms-button.html)

Don Lloyd

Changing Text in a Forms Button

Quickie !

Can the text in a button (Forms) be changed without selecting it.
If yes, how?

regards,
Don

K Dales[_2_]

Changing Text in a Forms Button

You can use the code:
sheets("Sheet1").[Button 1].Caption = "New Text"
substituting your sheet name and the button name (look in the Name Box on
the toolbar when the button is selected to see what the name is).

"Don Lloyd" wrote:

Quickie !

Can the text in a button (Forms) be changed without selecting it.
If yes, how?

regards,
Don

Don Lloyd

Changing Text in a Forms Button

Many thanks,
Don

"K Dales" wrote in message
...
You can use the code:
sheets("Sheet1").[Button 1].Caption = "New Text"
substituting your sheet name and the button name (look in the Name Box on
the toolbar when the button is selected to see what the name is).

"Don Lloyd" wrote:

Quickie !

Can the text in a button (Forms) be changed without selecting it.
If yes, how?

regards,
Don

All times are GMT +1. The time now is 10:29 AM.