Value of a cell being placed in a command button

[Romano_odK]

Good afternoon,

Is it possible to let a value be refresh in a command button and also have text next to it. So in this case I have a command button with the text "Stock <0" and underneath that text I would like to see the value from A4 in that button. Can this be done?

Thank you for your time.

 

[Candyman8019]

Yes. You can do that with VBA. For example:

Private Sub SetButtonCaptions()
CommandButton1.Caption = "Stock < 0" & Chr(10) & Sheet17.Range("I5").Value
End Sub

 

[Romano_odK]

Yes. You can do that with VBA. For example:

Private Sub SetButtonCaptions()
CommandButton1.Caption = "Stock < 0" & Chr(10) & Sheet17.Range("I5").Value
End Sub

Good evening, thank you for your reply. It indeed works when I push the button. Can it als refresh when I hit the Refresh All button, which it doesn't do now?

 

[Candyman8019]

If you're referring to the Refresh All on the data ribbon then no, that won't work...but you could set the sub to the following:

Private Sub worksheet_change(ByVal target As Range)
CommandButton1.Caption = "Stock < 0" & Chr(10) & Sheet17.Range("I5").Value
End Sub

This way, whenever any cell on the sheet is changed, it should refresh the button text.

 

[Romano_odK]

If you're referring to the Refresh All on the data ribbon then no, that won't work...but you could set the sub to the following:

Private Sub worksheet_change(ByVal target As Range)
CommandButton1.Caption = "Stock < 0" & Chr(10) & Sheet17.Range("I5").Value
End Sub

This way, whenever any cell on the sheet is changed, it should refresh the button text.

Thank you that is exactly what I needed. Have a great weekend.