View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anisha via OfficeKB.com anisha via OfficeKB.com is offline
external usenet poster
 
Posts: 5
Default button labelling

I am a beginner, so please help..., though it may be looking very simple to
you dt. 27/10/09

below is a macro DA which creates a button which on clicking will execute the
macro called DAmacro
How can i give a label to this button (eg. label "OK DAMACRO"). Now button1,
button2 etc. is appearing as label
Sub DA()
Dim myButton As Button
Set myButton = ActiveSheet.Buttons. _
Add(Left:=3, Top:=2, Height:=25, Width:=45)
myButton.OnAction = "DAmacro"
End Sub


Many many thanks in advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200910/1