Greetings,
I am trying to have Excel work like Word for text writing without using
WrapText. My project is to activate Ã* short VBA procedure each time the user
presses the space bar so that there is an automatic line change whenever the
number of characters reach a certain limit.
I can control the character limit with the Len function and the space bar
with Application.OnKey " " (I had to dream that one up as not part of the VBA
Help files).
The problem is that I can not find a way to allow the procedure to be
executed as long as the focus is on the cursor: the procedure works fine
otherwise.
Of course, I would then have to find a way to get the cursor back at it's
original place but I have to solve problem one first.
I am of course open to any other approach that would work.
Thank you for your help.
--
Popsie