Populating Dropdown box

[dave1167]

Hi
I need to create a user form which will have two dropdown combo boxes

The first one I want to populate with all the names of the worksheets in a workbook. This then needs to trigger populating the second combo box with a range within the selected worksheet from combobox1. It will always be the same range just different data in each sheet.

Anybody have any ideas

thanks in advance

Dave