Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Labelling X and Y axis | Excel Discussion (Misc queries) | |||
conditional labelling | Excel Discussion (Misc queries) | |||
CHARTS---X-Y labelling | Charts and Charting in Excel | |||
labelling | Excel Programming | |||
excel labelling | Excel Programming |