listbox populating on userform

Hello Everyone,

I have a problem with listbox on userform. i placed a listbox on userform and want to populate the listbox with different ranges and finally want to reference all the ranges in the listbox to one named range. for example listbox has a listindex of revenue(b8:f8) cost(b9:f9) and i want to mention revenue and cost as Range2 for chart range source. I tried to add items in the listbox by additems, rowsource but it is not populating any of these in the listbox when the listbox is displayed on the form in the frontend. Please help me.

by different range I mean that i want to populate revenue, cost, total in the listbox, now these revenue, cost and total is on the sheet1 as b8, b9,b10 and have revenue has range of (b8:f8), cost has range of (b9:f9), total has range of (b10:f10)

Karan

It's not clear what you are doing. What do you mean by using different ranges?

Don't answer in the original post

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!