Loading more than 255 characters into a userform textbox

I'm attempting to bypass the character limit in Excel for a textbox on a userform.

I have a function which I pass the form name, the textbox name and the text to laod.
My research shows that I need to use the .TEXTFRAME to insert more lines, the problem is that TEXTFRAME does not exist for userform textboxes.

Anyone have a workaround?

Here is my code:

Please Login or Register  to view this content.

Please take a few minutes to re-read the forum rules, and then edit your post to add CODE tags.

Thanks.

Thank you.

An ActiveX textbox isn't subject to the character limitations an autoshape's textframe.

This is some code i got from this forum for this problem

Please Login or Register  to view this content.

The problem is this is a userform, so I don't think I have access to the activeX textbox, the shapes or activesheet references.

Please Login or Register  to view this content.

That's 400 characters.

Don't forget to set the WordWrap and Multiline properties to True.

You're welcome.