Excel Macro

[rkymtngraz]

I would like to add a button in an Excel spreadsheet with a macro that does the following:

1. Copies a date field and a separate text field and appends them together.
2. Takes this new string (date: text) and appends it to a third field so that over time you would wind up with many date: text strings.
3. Clears the contents from the original two fields so that the user can make a new entry.

In effect this macro would keep an archive of project status while allowing the user to enter a new update in the same two fields each time.

 

[VoG]

Try like this

Sub Appnd()
Range("C" & Rows.Count).End(xlUp).Offset(1).Value = Format(Range("A1").Value, "dd-mm-yyyy") & ": " & Range("B1").Value
Range("A1:B1").ClearContents
End Sub

 

[rkymtngraz]

Since I am very new to this let me be more specific.

The user will enter a date into b29, text in c29
When user clicks button b29 appended to c29 and added to text already in c30. b29 and c29 are then cleared and the cursor left in b29. User
then enters new data into b29 and c29, etc.

Thanks for clarifying.

 

[VoG]

Try

Sub Appnd()
With Range("C30")
    .Value = .Value & Chr(10) & Format(Range("B29").Value, "dd-mm-yyyy") & ": " & Range("C29").Value
    .WrapText = True
End With
Range("B29:C29").ClearContents
Range("B29").Select
End Sub

 

[rkymtngraz]

Awesome. That works perfectly. Thanks for the help.