View Single Post
 
Old 06-19-2014, 08:17 AM
jpb103's Avatar
jpb103 jpb103 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: May 2014
Location: Thunder Bay, Ontario
Posts: 58
jpb103 is on a distinguished road
Default Retrieving Rich Text from a RTF Text box in a User Form

Hey fellas,

I've got a VBA userform that contains a Rich Text Box. I need to retrieve the text in this box and put it into a cell in a table on the parent word document. The problem I'm having is when I use .Text, it leaves out the formatting (for bullets and the like), and when I use .TextRTF, it just spews a bunch of garbage into the cell. I feel like I'm missing something simple, but I can't put my finger on it. Any thoughts, VBA community?
Reply With Quote