userform listbox

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