Why Form Combobox VBA do not fill the combobox? Please help!

Hi all,

I am not sure where my script has gone wrong.

See attached excel file.

I am trying to have a few comboboxes which will return the quantity depending on the DATE, BARS.

I have created the date without issue. However the Bars did not work because when I select the from the drop down list, the box appear blank.

As well - how to write a script that if a particular bar is selected, what Items did they order using vertical data to appear horizontally and has to be Unique list too?

Thanks in advance.