command button

[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.

 

[Don Guillett]

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

 

[CellShocked]

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

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".