If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
Excel Formula | yuki | Worksheet Functions | 7 | September 28th, 2004 02:40 AM |
Add to formula | Pat | Worksheet Functions | 16 | September 24th, 2004 03:38 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |