It's difficult to know what 'the text' on the button is but as that is
unlikely to change this is how you would paste a constant text in a cell(s)

Sub PutTextInCell()
Selection.Value="MyText"
End Sub

Places MyText in the selected cell(s)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"famdamly" wrote in
message ...

I need a macro that I can assign to a button that when pressed will copy
the text that is on that button into a cell. I'm stumped, ok well I
didn't even try because I know I would be up all night trying then I'd
ask anyway, so I'll just ask now.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=560553