userform listbox

This is confusing me somewhat, sorry.

ListItems = Range("yourRangeName").Value

Does this mean I need to have my "range names" in a "range" itself as to pick up for listbox??

I have 52 range names for the weeks of the year. Example Wk1_Jan_07,Wk2_Jan_07 and so on. These are names of ranges 15 rows high 12 columns wide.

The listbox will allow you to choose a week then I assume case statement will allow choice to be run afterwords (working on this code therory).

Also, this line in second sub "Private Sub UserForm1_Initialize()" gives me an ambiguous name detected: userform1_initialize error?

Here is microsofts help support site that shows how to populate a listbox using multiple ranges

http://support.microsoft.com/?kbid=161534

Okay, I think I am getting this....
In your userform, you want to select a range from the list box for your calculations...........


Or do you want to select a range from a list box and that selection populates another listbox??

Originally Posted by Zrx

Thanks Dave,

Beacuse of this line in the help file

"The items in the ranges A1:A3 and C1:C3 on Sheet1 are read into an array and are then assigned to the list of ListBox1. "

I will need to rethink my plan.

As I said I don't need the "items" in the "range name" just want to use the range name as a "string" I guess so the case statements can pick from there and then the case will do the work for that picked "string".

Ralph