load user form text box using mid

[erock24]

i'm using the following code to load a text box in my userform. How can I edit it so that I only load text starting from character 37 to end. Something like this maybe...mid(ImpCom,37,400)

Please Login or Register  to view this content.

p.s. I tried

Please Login or Register  to view this content.

and it didn't work.
Thanks

[royUK]

Try this, you don't need to set focus

Please Login or Register  to view this content.

[erock24]

works great thank you.

[royUK]

No problem glad it helped.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save