Formatting values with VBA.

[dbmathis]

With the following line:

c.Comment.Text Text:="Worklog: " & c.Offset(0, 1).Value & Chr(10) & c.Value

How would I go about formatting this part BOLD:

"Worklog: " & c.Offset(0, 1).Value

Thanks.

 

[Norie]

This can be done.

I can't supply any code at the moment, I've had to totally scrub my machine and haven't yet installed Office.

What I would suggest is recording a macro when you do it manually, that's actually the way I would approach.