Value list in Excel 2000 list box

[mmr3b9]

I'm trying to make a list box in Excel that takes a value list from a semicolon deliminted string (ie, "how; now; brown; cow&quot. In Access, I'd just set the RowSourceType to "Value List" and then assign the string to RowSource, but there isn't any RowSourceType in Excel.

I know I could make a list on a worksheet and then set the RowSource to equal that, but that's messy and I'd like to avoid doing it.

Thank you.

 

[SkipVought]

mmr3b9,

You must be using a listbox on a woeksheet and not in a userform.

In a worksheet use ListFillRange

In a userform use RowSource



Skip,

http://www.TheOfficeExperts.com