Onclick button actions

[dstansbie]

Good morning all,

Is it possible to click a self made button in a Excel worksheet that
then carries a value into a macro?

I want to have a page where when a button is pressed ie November the
value is carried to a macro that then inserts it into the open file
code.

There is probably an easier way to do this but this is a challenge.

thanks

Dave

 

[Chrisso]

Try:

Sub Your_Button1_Click()
Debug.Print
ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text
End Sub

This will get you the buttons text.

Chrisso