You missed a leading apostrophe--or was that a typo in the post?

'Storage Locations'!$A$2:$A$20

And you're sure you have a sheet named "Storage Locations"?

"Patrick C. Simonds" wrote:

I tried entering:

Storage Locations'!$A$2:$A$20

The error I get is Invalid Property value. I am doing this in the
properties area of the ListBox.

"dan dungan" wrote in message
...
In Excel 2000, I just typed a2:a20 in the listbox properties
rowsource.

What have you tried?
How did it fail?

--

Dave Peterson