insert validation in sheet

  • Thread starter Thread starter efi
  • Start date Start date
E

efi

Hi,
How can I insert in my code function that set for a specific column the
validation condition of string 1-15 chars without blanks?

thanks.
 
You don't have to use a macro
Check out Data>validation in the menubar

See text length
 
Try This

In a custom validation formula

=AND(ISERROR(FIND(" ",C1,1)),AND(LEN(C1)>0,LEN(C1)<=15))

"C1" is a example cell


Regards Fernando Ortiz


Ron de Bruin said:
You don't have to use a macro
Check out Data>validation in the menubar

See text length
Click to expand...
 
Try This

In a custom validation formula

=AND(ISERROR(FIND(" ",C1,1)),AND(LEN(C1)>0,LEN(C1)<=15))

"C1" is a example cell


Regards Fernando Ortiz


Ron de Bruin said:
You don't have to use a macro
Check out Data>validation in the menubar

See text length
Click to expand...
 
Hi,
I think that you didn't understand my problem, I will explain it
again:
I want in my code to access the variables of validation , how can I do
it , with whicj object.
Anyway thanks for your replies.
 
Hi Efi

Turn on your macro recorder and do the steps you want in Data>Validation in the menubar
 
Back
Top