Dependent Combobox on Form not updating from dynamic range

Hi guys,

I've been snooping around this site for a while and with good observation and your kind help I've been venturing into writing a bit of code myself.

The attached is just the beginning, which are parameters needed to know the directory and file name of a text file I import into excel on a very regular basis.

PROBLEM:
The question is that combobox for day is dependent on year and day, which dynamically changes the worddays on named range DaysList. However, when I make changes to year and month, the name range changes but not the list on the combobox. I've been trying to update the list with different techniques, but not working yet.

Don't pay attention to the code I have for the command button, that was just practice as this is my first time dealing with forms.

Help please...

Hello ron2k_1,

Please check your Excel file before posting. There is an error in the posted file that crashes Excel when it starts. It may have become corrupt when uploaded or happen on your end. Either way, it the file needs your attention.

Oh, really sorry for that. Hopefully I didn't messed up anyother important work you may had been working on.

I open the file. And the only thing that I saw with errors was the the button to show the form. There is only my practice macro on the wb, so reassigning the macro to the button and saving the wb on the desktop did it for me.

I'll appreciate it if you give it another shot... [Save all other excel work, just in case.... )

Try this one Ron.

Please Login or Register  to view this content.