command button

  • Thread starter Thread starter borjan
  • Start date Start date
B

borjan

I want the caption in a command button to change with a cell that changes due
to a
vlookup formula, meaning; when cell content changes the caption in the
command button changes.
 
I don't use command buttons but here is a way to change the text in a shape
or drawing object

'With ActiveSheet.Shapes(1).TextFrame
' .Characters.Text = "abcdefg"
' .Characters(3, 1).Font.Bold = True
 
I don't use command buttons but here is a way to change the text in a shape
or drawing object

'With ActiveSheet.Shapes(1).TextFrame
' .Characters.Text = "abcdefg"
' .Characters(3, 1).Font.Bold = True
Click to expand...


After I create a button, I always found that there is an option for
editing the "button text". It is independent of the button function
assignment.

Press Ctrl and right click, and select "edit text".
 
Back
Top