Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Onclick button actions
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Onclick button actions
Try:
Sub Your_Button1_Click() Debug.Print ActiveSheet.Shapes(Application.Caller).TextFrame.C haracters.Text End Sub This will get you the buttons text. Chrisso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Undo Command Button Actions | Excel Programming | |||
OnClick | Excel Discussion (Misc queries) | |||
Actions between user actions | Excel Programming | |||
onClick in Excel | Excel Programming | |||
Command Button OnClick | Excel Programming |