I'm new here on this forum. I read lots of topics before I registered myself.
I'm quite new on VBA programming. Although I understand the basics I've sometimes some difficulties to discover the right expressions to get what I want.
At this moment I'm on a little project to make a messaging tool for communication ground-air.
In this tool I've a text box in which one is able to typ a message for air crew. The problem is (multi line is set on) that the whole message will appear on 1 line in the final message. The visible line breaks in the text box aren't real line breaks. I would like to have an automated line break after every 40 characters (spaces included) every time the text exceeds 40 characters.
I came up with this code which, of course, doesn't work:
Formula:Please Login or Register to view this content.
The question is: why? I would like to have VBA put a "vbNewLine" (new line) every time the character amount exceeds 40. Its seems to be more difficult than I thought. Or maybe I'm close, but took a wrong code somewhere.
Thanks a lot!