Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for button name
Is it possible to assign name of a button as a formula i.e. e.g. the content
of cell C4? |
#2
|
|||
|
|||
If the button is a Control Toolbox button, you can use the following Change
event macro to change the caption of the button to whatever is currently in C4. This is a sheet macro and must be located in the module for that sheet. Right-click on the sheet tab and select View Code, then paste this macro into the displayed module Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Address(0, 0) = "C4" Then _ CommandButton1.Caption = Target.Value End Sub "Adam" wrote in message ... Is it possible to assign name of a button as a formula i.e. e.g. the content of cell C4? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |