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" <(E-Mail Removed)> wrote in message
news:E7A0A338-6F60-484A-9C63-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:E7A0A338-6F60-484A-9C63-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:31421949-99F1-400F-909F-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:E7A0A338-6F60-484A-9C63-(E-Mail Removed)...
> > > 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
> >
> >
> >