Formula for button name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to assign name of a button as a formula i.e. e.g. the content
of cell C4?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Learning arrays. 13
Count number of rows with specific text 2
Calculation using IF 6
Calculation using IF 1
Formulas 5
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Copying a formula containing the INDIRECT function 7
Subtracting based on 2 conditions 3

Back
Top