| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can the Text on a button form be referenced from a cell?
I have several macros that I use to perform tasks in a spread sheet. This
sheet is used for several different types of data that I import. I have generic buttons titles that describe the function the button will perform. I'd like the title of the button to change depending on what type of data I've imported. For example: If cell A1 has the text Tractor House in it, then I want the text on the button to say Print Tractor House. But if the text in cell A1 is Truck Paper then the text on the button to say Print Truck Paper. Can this be done in Excel with VB? Don |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text from Referenced cell truncated | Excel Worksheet Functions | |||
| bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Form Button - Changing Text | Excel Discussion (Misc queries) | |||
| I need to put text after the value of a referenced cell (=B4'MS') | Excel Worksheet Functions | |||
Threaded Mode
