Formatting values with VBA.

dbmathis

Well-known Member
Joined
Sep 22, 2002
Messages
1,064
With the following line:

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

How would I go about formatting this part BOLD:

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

Thanks.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,102
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,268
Messages
5,577,102
Members
412,768
Latest member
klig
Top