Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format text through vba
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format text through vba
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? |
#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? |
Reply |
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 |