Update Listbox Rowsource when combobox_change in userform

Dear All,

I m not able to update listbox rowsource when combox selection will change.

PLease help.My code are as below.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Something like that, you dont pass the range itself in, a string of what the range will be like "Sheet1!A2:A10000"

Thankyou! Nathan

Sorry! not to specify details.

I have sheetnames in my combobox rowsource. So each time a combox selection change, it search for sheetname in workbook and listbox rowsource will be for the selected sheet.

e.g. If i select sheet1 in combobox listbox rowsource will be sheet1.range(xyz) and if i select sheet2 in combobox,listbox rowsource will be sheet2.range(xyz).

My workbook having more than 25 sheets.

Hope it clears my question
Regards,
Vishnu

Ok, so you want it to be made up of say x records from sheet1 and y records from sheet2 etc?

If not, why are you looping the sheets, for containing the sheet name, why not just reference the sheet?

Please Login or Register  to view this content.