擅长:python、mysql、java
<p>在excelvba中,需要使用<code>Range</code>对象的<code>Characters</code>属性。例如:</p>
<pre><code>Sub Test()
Dim rngCell As Range
Dim lngPos As Long
'get cell
Set rngCell = Sheet1.Range("A1")
'find linebreak
lngPos = InStr(1, rngCell.Value, vbLf, vbBinaryCompare)
'format either side
rngCell.Characters(1, lngPos).Font.Bold = True
rngCell.Characters(lngPos + 1, Len(rngCell.Value) - lngPos).Font.Color = 1234
End Sub
</code></pre>
<p>格式如下:</p>
<p><a href="https://i.stack.imgur.com/VQLDb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VQLDb.png" alt="enter image description here"/></a></p>