PDA

View Full Version : Buttons thats copy the Caption in a cell



ferrugo
10-21-2008, 05:27 AM
hi (sorry about de Bad english)
Please, im trying create a macro that copy a caption off the button and paste in a cell
*** But the same macro runs with every buttons (with any button name)

Explain Again: The Macro tha run with a many buttons. When i click it, the caption wil copy in a cell.

Thanks a lot...:banghead:

Bob Phillips
10-21-2008, 05:43 AM
Assign this macro to all buttons



Public Sub ButtonCaption()

ActiveCell.Value = ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text
End Sub

ferrugo
10-21-2008, 05:57 AM
Hey.
Many thanks..
Sorry about the simple doubt..