I've been dancing around this problem for weeks now with no idea how to solve it...
I would like to add names that are in another workbook into a dropdown list...the only problem is that they need to be sorted alphabetically first but only in the dropdown and not in the worksheet...
So all i need to know is how to reference the dropdown list to .addItem? And is there someway to sort the items listed in the dropdown? Also, how can I give my dropdown a title that shows when it is idle?
Many thanks!!!
I would like to add names that are in another workbook into a dropdown list...the only problem is that they need to be sorted alphabetically first but only in the dropdown and not in the worksheet...
So all i need to know is how to reference the dropdown list to .addItem? And is there someway to sort the items listed in the dropdown? Also, how can I give my dropdown a title that shows when it is idle?
Many thanks!!!