| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert validation in sheet
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
insert validation in sheet
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
insert validation in sheet
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert sheet tab is not functioning and can't add new sheet | Excel Worksheet Functions | |||
| Insert Sheet | Excel Worksheet Functions | |||
| Data Validation - Insert Row | Excel Worksheet Functions | |||
| insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
| Embedding an "insert row" macro with data validation | Excel Worksheet Functions | |||
Hybrid Mode
