Range in a userform

[Karthik Thandapani]

Hello,

I have a requirement for which I'm trying to capture a range and show that in an userform. The main idea is to list out the sheetnames one by one in a range and capture that in a userform/listbox so users can select them on.

Please find the attached file. Any help would be much appreciated.

Thanks,
Karthik

 

[Debraj]

In List box, try to use Row Source Property like below

 

[Karthik Thandapani]

@Debraj : it works like a breeze. Thank you!
Also, can you please tell me how can I enable multiple select inside the ListBox please?

 

[Karthik Thandapani]

got it. It's right above the rowSource ;-)