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

button labelling
 

The caption property

Sub DA()
Dim myButton As Button
Set myButton = ActiveSheet.Buttons. _
Add(Left:=3, Top:=2, Height:=25, Width:=45)
myButton.OnAction = "DAmacro"
myButton.Caption = "DAmacro"
End Sub


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=148188

button labelling
 

hi Joel Thanks a lot, very easily done. thankyou ,

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