Name a button

[mortenkh]

Hi every1.

I hope some1 in here can help me.

I have a macro which creat a new sheet with a botton which have a macro.
Below you see the macro i have, and it is working perfect.


Set t = ActiveSheet.Range(Cells(2, 15), Cells(2, 15))
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)
btn.OnAction = "Modversion2.OpdateBlokVersion2"



Now i just want the bottons name to be ("Update data") instead of botton 1.
I believe i only need 1 line of text (Might be wrong here)

Can any1 help me with naming my botton?

Thanks alot in advance.

 

[krausr79]

is it
btn.caption = "Update data"
?

 

[wideboydixon]

Set t = ActiveSheet.Range(Cells(2, 15), Cells(2, 15))
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)
btn.Caption = "Update data"
btn.OnAction = "Modversion2.OpdateBlokVersion2"

WBD

 

[mortenkh]

Hello Krausr79 and Wideboydixon

Yes that was exactly what i needed to know :D

Thanks alot for helping me this is highly appriciated

Have a nice day