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

VBA code will not run when the user is editing in a cell, so you have
consider a different concept.
If the user is typing into a text box then you can monitor this input as you
wish.
When finished, you transfer the text to the required cell.

NickHK

"André Boileau" wrote in message
...
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

Hello Nick,
There must be some way I can change the property of a cell or a group of
cell to limit the number of characters it will accept?
Thanks for your help.
--
Popsie


"NickHK" wrote:

VBA code will not run when the user is editing in a cell, so you have
consider a different concept.
If the user is typing into a text box then you can monitor this input as you
wish.
When finished, you transfer the text to the required cell.

NickHK

"André Boileau" wrote in message
...
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

André,
Yes, you can with Data Validation, but that is not what you asked.
Otherwise you have the _Change and _SelectionChange events to monitor what
is happening on your worksheet.

NickHK

"André Boileau" wrote in message
...
Hello Nick,
There must be some way I can change the property of a cell or a group of
cell to limit the number of characters it will accept?
Thanks for your help.
--
Popsie


"NickHK" wrote:

VBA code will not run when the user is editing in a cell, so you have
consider a different concept.
If the user is typing into a text box then you can monitor this input as
you
wish.
When finished, you transfer the text to the required cell.

NickHK

"André Boileau" wrote in message
...
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