Using Command Button to post on another sheet!
Closed
cmedlar
TrowaD
- Posts
- 1
- Registration date
- Wednesday November 4, 2015
- Status
- Member
- Last seen
- November 4, 2015
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Using Command Button to post on another sheet!
- Excel vba add command button programmatically - How-To - Excel
- Excel VBA add command button programatically - Guide
- Facebook remove send message button from post - Guide
- Creating search and update command buttons in a userform ✓ - Forum - Excel
- VBA code for command button ✓ - Forum - Excel
1 reply
TrowaD
Nov 5, 2015 at 11:02 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Nov 5, 2015 at 11:02 AM
Hi Colin,
This is the code line you are looking for:
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Range("A1").Value
How you use it depends on the type of command button you use (Using form > create module; Using activeX > paste line between the 2 existing ones).
Can you take it from here?
Best regards,
Trowa
This is the code line you are looking for:
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Range("A1").Value
How you use it depends on the type of command button you use (Using form > create module; Using activeX > paste line between the 2 existing ones).
Can you take it from here?
Best regards,
Trowa