Formatting a string within a textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

serveral years' comments have to be merged into one textbox, i would like to
make each year number standingout that might mean some formatting are needed
within an expression. how can i do it

clara
 
clara said:
serveral years' comments have to be merged into one textbox, i would like to
make each year number standingout that might mean some formatting are needed
within an expression. how can i do it


The formatting properties apply to the entire text box, not
to parts of it.

How about starting each year's comment on a new line (use
Chr(13) & Chr(10) as the new line sequence. or in VBA the
constant vbCrLf).
 
Back
Top