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.

On Sun, 24 Jan 2010 10:34:21 -0600, "Don Guillett"
wrote:

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