| View previous topic :: View next topic |
| Author |
Message |
ultine
General User
Joined: 08 Mar 2012
Posts: 9
|
 Posted: Sat Mar 10, 2012 9:00 pm Post subject: Change weight of some text being inserted into a text box |
 |
|
I have some text from a cell that is currently being inserted into a text box. The macro selects a cell, inserts that text into the text box, then selects another cell, and inserts that text into the box. That is all working fine.
Here is my problem: I would like to have some of the cell values be entered with bold text, but not all of them. When all is said and done, I would like to have a text box with a series of cell values in it, and some of those values will be bold.
| Code: | | oSheet.DrawPage(0).getControl.String = oSheet.DrawPage(0).getControl.String & " - " & sCellText |
That line of code is nested in a loop (along with a bunch of other code) and sCellText is simply the selected cell's string value.
I assume (know) that I will need to have my text box set to have multiline and formatting turned on, but I have no idea how to get the string to be inserted as bold.
Any help is, as always, greatly appreciated  |
|
| Back to top |
|
 |
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
|
| Back to top |
|
|
ultine
General User
Joined: 08 Mar 2012
Posts: 9
|
| Posted: Sun Mar 11, 2012 11:07 pm Post subject: |
|
|
| Thanks, Robert, that looks like it could be helpful. I will check it out more over the next few days. If anyone else has different input, it is still welcome, but that link certainly seems to have some of the syntax I was looking for. |
|
| Back to top |
|
|
|
