| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Text in a Forms Button
Quickie !
Can the text in a button (Forms) be changed without selecting it. If yes, how? regards, Don |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing text on a button | Excel Discussion (Misc queries) | |||
| Form Button - Changing Text | Excel Discussion (Misc queries) | |||
| Command button on forms | Excel Discussion (Misc queries) | |||
| Changing Forms | Excel Programming | |||
| Option Button and forms | Excel Programming | |||
Linear Mode
