| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
format text through vba
very nice....thank you!
"NickHK" wrote: Steve, You have to work with the .characters property of the range, similar to MID( ). Something like this : dim PriceStr as string const Msg as string=""Additional Delivery Fee of $" pricestr=Worksheets("Calculations").Range("Partial FreightPrice").Text With Worksheets(QuoteForm).Range("A" & DataRow) .Value = Msg & pricestr & " / Delivery if customer request additional deliveries" .Characters(len(msg)+1,len(pricestr).font.bold=tru e end with NickHK "steve" ... I use the following code to insert a line of text into a quote sheet: Worksheets(QuoteForm).Range("A" & DataRow).Value = "Additional Delivery Fee of $" & Worksheets("Calculations").Range("PartialFreightPr ice").Text & " / Delivery if customer request additional deliveries" Is there a way I can make the Worksheets("Calculations").Range("PartialFreightPr ice").Text BOLD? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
| how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Threaded Mode
