I have done this before using AutoCorrect.
Simply have autocorrect replace a preselected character or string of
characters with the appropriate symbol. YOu can also get the "bullet" on
multiple lines in the same cell after an <Alt+<Enter

"Marsh" wrote:

Good Morning,
A group of 22 users have asked if it possibe to insert bullets into text
entries in a column, for example column H. Inserting a Symbol is not
convenient. I did a search and found the following answer to this question
back in Feb 2006,
A simple code line

Set TB = UserForm1.TextBox1
TB.Value= Replace(TB.Value, CHR$(10), "* ")

should do the trick.
I am not a programmer. Could someone please let me know how I can implement
this into our file
THank you
Marsh