Thread: command button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
CellShocked CellShocked is offline
external usenet poster
 
Posts: 277
Default command button

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