| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation through VBA using string has 255 char limit??????
Hi
I have some VBA that dynamically changes validation lists based on selections in the workbook. Due to the complexity of the data being referenced the lists are built up into strings like "blah1, blah2, blah3,blah4" they are tthen added with.. ..Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=strLis where strList is the string holding the list the problem is that it fails consistently on some options. In those cases the list seems to be over 255 characters long Is this a known limitation of using this method as opposed to a named range as the source? If so is there a way around it...... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve certain char within a string? | Excel Discussion (Misc queries) | |||
| How do I get around the 255 char limit? | Links and Linking in Excel | |||
| string/char CONTAINS function? | Excel Worksheet Functions | |||
| LIMIT NUMBER OF CHAR IN A COMBINE CELL | Excel Discussion (Misc queries) | |||
| Limit to 50 char only | Excel Programming | |||
![Allan[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
