Macro for pasting text in a cell

[trevolly]

Hi all,

I'm wondering if anyone can advice on any vba code that could help me. I would like to be able to select a cell and then press a macro linked button which would then paste / enter text in to that cell. The text would be in the form of.....

Ops 1:
Ops 2:
LDR 3:
LDR 4:
LDR 5:
LDR 6:
LDR 7:
LDR 8:
LDR 9:
LDR 10:

Id appreciate any help.

Regards T

 

[6StringJazzer]

You want all of those rows of text in a single cell? Create a button and associate with this macro:

Public Sub LoadText()

   ActiveCell.Value = _
         "Ops 1:" & char(10) & _
         "Ops 2:" & char(10) & _
         "LDR 3:" & char(10) & _
         "LDR 4:" & char(10) & _
         "LDR 5:" & char(10) & _
         "LDR 6:" & char(10) & _
         "LDR 7:" & char(10) & _
         "LDR 8:" & char(10) & _
         "LDR 9:" & char(10) & _
         "LDR 10:"
         
End Sub