how to populate listbox with named range

Hello Everyone,

Plz help me with the attached spreadsheet. inside the spreadsheet there is a dynamic chart that changes the view by selection made in listbox on userform. this code actually used dialog box that is no longer supported in 2003/2007. I want to create similiar code n chart in 2003 n 2007.

When i try to populate listbox1 on userform i write

dim range2 as range

set range2 = range("b8:f8") &""& range("b9:f9")

with listbox1
.rowsource = range2

I am looking to use named range to populate data in listbox so when someone uses the range2 in chart source type, we have to mention just range2 and inside range2 it contains different range like (b8:f8) (b9:f9) (b10:f10) n all these different ranges are listed in listbox as revenue(b8:f8) cost(b9:f9) total cost(b10:f10) so when i select revenue from listbox chart range will select range2 (b8:f8) likewise. Please help me.