View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marsh Marsh is offline
external usenet poster
 
Posts: 37
Default Format text entries with code - Excel 2007

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