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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

You don't have to use a macro
Check out Datavalidation in the menubar

See text length

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"efi" wrote in message ...
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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" escribió en el mensaje
...
You don't have to use a macro
Check out Datavalidation in the menubar

See text length

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"efi" wrote in message
...
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

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" escribió en el mensaje
...
You don't have to use a macro
Check out Datavalidation in the menubar

See text length

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"efi" wrote in message
...
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Hi Efi

Turn on your macro recorder and do the steps you want in DataValidation in the menubar


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"efi" wrote in message ...
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

efi

You might want to have a look at Chip Pearson's pages on CF determination.

http://www.cpearson.com/excel/CFColors.htm

Gord Dibben XL2002

On Sun, 2 Nov 2003 01:34:48 -0500, efi
wrote:

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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/