Formatting text within VBA

D

David J. Braden

Hi,
How can I (or can I) format a string to be written to a cell *before* it
is put there? I'm encountering strings from html that I would like to
correctly represent in Excel (e.g., using bold font for text between
asterisks) without having to do it in situ within a cell. Any one of
these strings could be a mixture of bold, italic, and unemphasized fonts.

TIA
DaveB
 
D

David J. Braden

Hi Tom!
Thanks. Looks good. Sheesh, I have always thought that you are Der
Meister of publicly available info, but this tops the cake (with no
deference to Dick intended; indeed, thanks for the heads-up re his site).

Regards,
Dave

ps -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two formats within one cell 2
Find formatting in text in cell, insert tags around formatting. 2
Copying Cell Value AND Format into Email Body Macro 1
Formatting for the whole worksheet 1
Excel conditional formatting - how to make exceptions? 4
Conditional Formatting and Text Alignment 3
vba to convert htm tags 2
How can I add formatted text to a cell? 1

Top