How to store a large set of pulldown values..

Hi,

I have a set of 5000 values(around 62000 characters). I need to show all these 5000
values as a pulldown menu in an excel sheet.

Currently I have used the following statement:

with selection.validation

.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween, Formula1:=sPullDownValues
end with

where the string variable: 'sPullDownValues' contains a comma delimited string
of all the possible values.

A runtime error appears when I try to save these (62k) characters in the
string variable and assign it to the formula.

Anyone can please suggest me with an idea or an alternative solution
as to how to overcome this problem.

Any immediate help will be greatly appreciated.

THanks in ADvance,
Vikram