123Maximus
New Member
- Joined
- Dec 31, 2016
- Messages
- 13
Hello!
In Excel I have created some rectangles as buttons to which I want to connect macros.
Every time I click a 'button' it should send a certain word to an emty cell in column A (starting with A1).
I tried to record a macro and changed Range("A1") to "A" but it didn't work.
Sub Makro3()
'
' Macro3 Macro
' Sends the text Shoes
'
Range("A").Select
ActiveCell.FormulaR1C1 = "Shoes"
Range("A").Select
End Sub
My intention is to collect all the words in column A for further processing later.
Can anybody help me?
Thanks in advance and a Happy New Year!
In Excel I have created some rectangles as buttons to which I want to connect macros.
Every time I click a 'button' it should send a certain word to an emty cell in column A (starting with A1).
I tried to record a macro and changed Range("A1") to "A" but it didn't work.
Sub Makro3()
'
' Macro3 Macro
' Sends the text Shoes
'
Range("A").Select
ActiveCell.FormulaR1C1 = "Shoes"
Range("A").Select
End Sub
My intention is to collect all the words in column A for further processing later.
Can anybody help me?
Thanks in advance and a Happy New Year!