| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting text within VBA
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 -- Please keep response(s) solely within this thread. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting text within VBA
Hello David,
Maybe the approach (or a subset of) shown here at Dick's Blog. http://www.dicks-blog.com/archives/2...l-in-cells-ii/ -- Regards, Tom Ogilvy "David J. Braden" wrote in message ... 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 -- Please keep response(s) solely within this thread. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting text within VBA
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 - Tom Ogilvy wrote: Hello David, Maybe the approach (or a subset of) shown here at Dick's Blog. http://www.dicks-blog.com/archives/2...l-in-cells-ii/ -- Please keep response(s) solely within this thread. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting text within VBA
Dave,
Thanks and nice to talk to you again. -- Regards, Tom Ogilvy "David J. Braden" wrote in message ... 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 - Tom Ogilvy wrote: Hello David, Maybe the approach (or a subset of) shown here at Dick's Blog. http://www.dicks-blog.com/archives/2...l-in-cells-ii/ -- Please keep response(s) solely within this thread. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Text in cells that already have text entered | Excel Worksheet Functions | |||
| copying text within a text box and losing formatting | Excel Discussion (Misc queries) | |||
| Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Formatting text in a user form text box | Excel Programming | |||
Linear Mode
