K
Kjell
I want to write in maximum 34 sign in a cell. If I writes 1 signs moore I
want to get a warning. Is this possible in Excel Worksheet?
want to get a warning. Is this possible in Excel Worksheet?
B
Bob Phillips
Use data validation, allow type of custom, and a formula of
=LEN(A1)<=34
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
=LEN(A1)<=34
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
K
Kjell
Sorry. Don`t functions. May be I do something wrong?
Z
zz
well, in a cell write
=if(len(write_cell_ref_here)>34,"Too long","")
=if(len(write_cell_ref_here)>34,"Too long","")
K
Kjell
I am feeling like a fool. Not function. If I use A1 to write in a name, using
letters and numbers f.ex. "1. floor detector" I want to get a message on the
screen, in some way, if I, while I am writing, exceed a total of letters and
numbers of 34.
--
Kjell
zz skrev:
letters and numbers f.ex. "1. floor detector" I want to get a message on the
screen, in some way, if I, while I am writing, exceed a total of letters and
numbers of 34.
--
Kjell
zz skrev:
B
Bob Phillips
You can't get the error whilst you type, only after you hit enter.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
Kjell said:
Z
zz
when you type in a cell, excel goes into "edit mode" , that means, no macro
can called, no events are trigered and no code is executed until excel
leaves "edit mode".
excel is pretty much like Men's brain, it only can use half the brain at a
time
but you can do this, if you don't mind waiting until you finish typing
In data menu
* goto validation
in the first field .
* select "Text lenght" option
in the second one
* select "less than"
in the third one
* type you lenght limitation , eg "34"
* 'click' "Ok"
then in the error alert tab
* check "show error alert after invalid data entered"
in the first combo
* choose the type of alert [ stop,warning,info,etc.]
in the first field
* type the title of you error message eg. "Damn!, you cannot type that
much!!" ;-)
in the second field
* type the error description you want the user to read eg. "What do you
think i am?, notepad?" LOL,
sorry.... ejm, ejm
Now,
*type something into your validated cell,
and finally
* have some fun
--
hope this works, if doesn't, tell us please.
---
zz [MX]
cuasi-musico,semi-poeta y loco
can called, no events are trigered and no code is executed until excel
leaves "edit mode".
excel is pretty much like Men's brain, it only can use half the brain at a
time
but you can do this, if you don't mind waiting until you finish typing
In data menu
* goto validation
in the first field .
* select "Text lenght" option
in the second one
* select "less than"
in the third one
* type you lenght limitation , eg "34"
* 'click' "Ok"
then in the error alert tab
* check "show error alert after invalid data entered"
in the first combo
* choose the type of alert [ stop,warning,info,etc.]
in the first field
* type the title of you error message eg. "Damn!, you cannot type that
much!!" ;-)
in the second field
* type the error description you want the user to read eg. "What do you
think i am?, notepad?" LOL,
sorry.... ejm, ejm
Now,
*type something into your validated cell,
and finally
* have some fun
--
hope this works, if doesn't, tell us please.
---
zz [MX]
cuasi-musico,semi-poeta y loco
Bob Phillips said:
K
Kjell
OK. I understand. My half brain (the working part) can wait until typing is
finished.
Thank you zz and Bob, for spending time on me and my problem. Have a nice
day whatever yuo may be in the world.
--
Kjell
zz skrev:
finished.
Thank you zz and Bob, for spending time on me and my problem. Have a nice
day whatever yuo may be in the world.
--
Kjell
zz skrev:
when you type in a cell, excel goes into "edit mode" , that means, no macro
can called, no events are trigered and no code is executed until excel
leaves "edit mode".
excel is pretty much like Men's brain, it only can use half the brain at a
time
but you can do this, if you don't mind waiting until you finish typing
In data menu
* goto validation
in the first field .
* select "Text lenght" option
in the second one
* select "less than"
in the third one
* type you lenght limitation , eg "34"
* 'click' "Ok"
then in the error alert tab
* check "show error alert after invalid data entered"
in the first combo
* choose the type of alert [ stop,warning,info,etc.]
in the first field
* type the title of you error message eg. "Damn!, you cannot type that
much!!" ;-)
in the second field
* type the error description you want the user to read eg. "What do you
think i am?, notepad?" LOL,
sorry.... ejm, ejm
Now,
*type something into your validated cell,
and finally
* have some fun
--
hope this works, if doesn't, tell us please.
---
zz [MX]
cuasi-musico,semi-poeta y loco
Bob Phillips said: