View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Dorph Andy Dorph is offline
external usenet poster
 
Posts: 8
Default setting the caption in a button control

After entering the following line:
Set btn = ActiveSheet.Shapes.AddFormControl(xlButtonControl, 160, 28, 75,
23)

I try to change the caption by using

btn.Caption = "caption"

I receive an error when the code runs. What am I doing wrong? How can I
get this to work?

TIA