I tried looking all over the web for the answer to this one. I have a textbox set to multiline and I want my end users to be able to select a portion of their text and change it to bold or italic etc.
I have tried using the
But when you change it nothing happens to the text box.application.dialog(xldialogfontproperties).show
I have rearched and found many articles for a rich text box, but I dont have that option on my userform toolbox, nor in the additional controls
Hello rbyrd023,
Unfortunately a standard Text Box, be it Forms or ActiveX, only allows for a single font style. You might want to use a Shape object as your text box. The users could edit the text and change colors, font styles, and sizes.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
By the way.... This is in a Userform, not on a worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks