I have a workbook that inserts sheets from a template, and after it is inserted I want to create a worksheet dropdown list that references a range of dates on another worksheet. When trying to define the ListFillRange of the DropDown list, it gives me returns "
Run-time error '-2147417848 (80010108)':
Method 'ListFillRange' of object 'DropDown1' failed
" Here is the code:
According to http://support.microsoft.com/d…aspx?scid=kb;en-us;270589 the problem has to do with late binding. I have had a lot of difficulty coming up with anything about early binding and something similar to a worksheet combobox. Thanks for any help!