Thread: Macro button
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Macro button

With ActiveSheet.DrawingObjects(Application.Caller)
..Text = "Clicked me!"
End With

Tim

"LeBob" wrote in
message ...

Hi,

I've writtten a macro under VBA and associate it to a button (Display,
toolbar, form).
Is it possible to be connected with this button in my vba code to
modify its caption for instance ??
YES ???
Great !!
How ???

Thanks


--
LeBob
------------------------------------------------------------------------
LeBob's Profile:
http://www.excelforum.com/member.php...o&userid=31185
View this thread: http://www.excelforum.com/showthread...hreadid=508563