how to add bullet list of text items in cell

  • Thread starter Thread starter kurb
  • Start date Start date
K

kurb

Hello

I need to maintain relationships between column and row headings in text
format.

How may I add a bullet list of line items in a cell, eg

* item1
* item2
* item3


Is there a way of adding a bullet to the next line, or adding a new line
of text, when I enter say Carriage Return?

Thanks for any suggestions

K
 
when editing a cell, type Ctrl+Enter to for a crlf

in code
Sub AddText()
Selection.Value = "ABC" & vbCrLf & "DEF"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding i new item to current data validation list 2
Combobox with a dynamic list 12
Different spaces between bullet points in same bullet list 1
how to add bullet formatting to excel text 2
find the data of the corresponding column 2
How do I decompose a string for a report 2
Help needed in Excel macro 1
Inserting a character into a cell that has text. 5

Back
Top