userform listbox vba

[adamheon]

I'm looking to populate a listbox on a userform with the following:



populate list box with cell C5 downward if adjacent cell D5 = "" (blank)

worksheet name = CONSTRUCTION

[Andy Pope]

one way

Please Login or Register  to view this content.

[adamheon]

How would i specify the worksheet name? i see your example sheet works perfect...but my workbook has mulitple sheets.

[Andy Pope]

just include a reference to it for all existing references to ranges. Use With to reduce amount of code required

Please Login or Register  to view this content.