listbox populating on userform with named range

Hello Everyone,


1.
want to create a named range range2 and want to set range (b8:f8), (b9:f9) and (b10:f10) under it, this I want to do so that I can use named range range2 as chartrange source. I want to populate revenue(b8:f8), cost (b9:f9) and total (b10:f10) in listbox, so when i select revenue from listbox it should refer to range2 (b8:f8) and accordingly change the chart graph, when i select cost from listbox it should refere to range2(b9:f9) and accordingly change the chart graph shwing cost figures.

Please find the attached spreadsheet with 2 userforms and description of the problem. help is appreciated. Thanks in advance.

Karan

Hi,

Thanks for your solution, but unfortunately its not running. can you please look into the spreadsheet and try to run it. I tried and its not running. There are 2 userform and I am looking for solving both of them. please refer to the spreadsheet, and for userform1 i want to populate range in listbox not in combobox. Please help. Thanks

Karan

Hello Everyone,


1.
want to create a named range range2 and want to set range (b8:f8), (b9:f9) and (b10:f10) under it, this I want to do so that I can use named range range2 as chartrange source. I want to populate revenue(b8:f8), cost (b9:f9) and total (b10:f10) in listbox, so when i select revenue from listbox it should refer to range2 (b8:f8) and accordingly change the chart graph, when i select cost from listbox it should refere to range2(b9:f9) and accordingly change the chart graph shwing cost figures.

Please find the attached spreadsheet with 2 userforms and description of the problem. help is appreciated. Thanks in advance.