How to read the contents of an OLEObject (dropdown list) in excel

[furrelkt]

instead of:[vba]buf = Split(o.Object.Values, ";")[/vba]use:
[vba]buf = Split(o.Object.DisplayValues, ";")[/vba]

Note that your resize isn't big enough to accommodate the last entry since split returns a zero based array, not a 1 based array, so you'll miss the last entry..

Thank you so much for this. :-)

It seems as it is getting the last value. :-)

Thank you so much for your help.

Also, everytime i go to scroll...it quits excel and restarts... as well as i notice that some of the entries or names are coming over like

"AmTrust Bank - (OSBOH)"
Arvest Bank Operations, Inc. - (ABOAR)
"Asiatrust Development Bank (ASTPH)"

with the quotes i mean...

Edit: I can clean this up, without the qoutes. i so appreciate your help.

Keri