enter today's date + text

[srikanthg2310]

I need a macro which will enter " today's date + text" . when i press alt + enter and run the macro again in a single cell it should again insert the same. please help. thank you.

 

[oldbrewer]

so whichever cell is highlighted you want to replace the contents with "today's date and text"
OR
with say 21/11/2015 text

 

[srikanthg2310]

21/11/2015 abcd and then alt +enter
21/11/2015 abcd

 

[oldbrewer]

not sure I understand what you want - just put the current date followed by "abcd" in the highlighted cell ?

 

[Jim885]

Try this;

Sub Date_Text()
    ActiveCell.Value = Format(Now(), "d/mm/yyyy") & " ABCD"
End Sub

You can then assign your keyboard shortcut to the macro. However, it is usually Cntrl + a character
But Alt + F8 will show you the macro list, then you can press Run

 

[Macropod]

This looks like a repeat of your discussion in this thread: http://www.mrexcel.com/forum/excel-questions/903006-multiple-lines-single-cell.html#post4345800

 

[srikanthg2310]

thank you.. but i have one more question. after i run the macro in a given cell and then i hit alt+enter it goes to a new line in the same cell.
I want to run the macro again in the same cell in the next line but it is not working. please help.

 

[Macropod]

Sub Date_Text()
With ActiveCell
  .Value = Format(Now(), "d/mm/yyyy") & " ABCD" & Chr(10) & .Value
End With
End Sub

 

[srikanthg2310]

thank you paul, that was perfect