1

I am working on dynamic creation of dropdown using VB.Net and SpreadsheetGear dll and populate it with values as below

worksheet.Range(Range).Validation.Add(ValidationType.List, ValidationAlertStyle.Stop,
ValidationOperator.Between, flatList, "") I am using validation.add to create the dropdown

here flatList is the comma seperated string dropdown values.

It is working FINE with flatlist characters less than 255 characters, but if it is more than 255 it throws below ERROR message

 **Data Validation lists are limited to 255 characters.**

Kindly Help Ramesh.T.

Ramesh
  • 103
  • 1
  • 10
  • 1
    I think it is an Excel limitation, you can use a named range instead and put the valid data in that range. – assylias Aug 17 '12 at 07:08
  • I want to add this dropdown only through VB.Net code. May i know if Named range is possible through vb.net, If so can you please help me in providing reference link URL. – Ramesh Aug 17 '12 at 09:31
  • [this post](http://stackoverflow.com/questions/7805207/how-to-create-dropdownlist-on-excel-2003) might help. – assylias Aug 17 '12 at 09:36

0 Answers0