ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Rich Text Box (https://www.excelbanter.com/excel-programming/328506-rich-text-box.html)

Randall[_5_]

Rich Text Box
 
I code that imports Texts file into Excel and I then I have a script
that bolds the keywords. I want to move the text files to a user form
so it is easier for a user to edit the data. I found out I have to use
a rich text box in order make the keywords in bold. I can the open the
file with:

MyRichTextBox.loadfile("C:\TEST.TXT")

Then I still do not know how to make the keyword bold. And when I try
to save the text file it will only save as a Rich Text File. I tried

MyRichTextBox.savefile("C:\TEST1.TXT",RichTextBoxS treamType.PlainT*ext)


But VBA does not like
RichTextBoxStreamType.PlainT*ext

This only works MyRichTextBox.savefile("C:\TEST1.TXT") Then I get Rich
Text File data.

Can anyone help?



All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com