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.

To add items in combobox, do the following:

Double click the userform to go into the VBA window of the userform. There are 2 dropdown boxes at the top of the window, one is named "userform" and one is named "click". Change the click to "Initialize". Once you do it, this code will show in the window:

Please Login or Register  to view this content.

Here is where you will add the items:

Please Login or Register  to view this content.

Thanks kjy1989 but it did not work nor I can find the UserForm_Initialize()

I am not using UserForm. I created comboboxes using Form and assigned macro to it with VB script.

Code as below

Sheet2(Sheet2)

Please Login or Register  to view this content.

Module 2

Please Login or Register  to view this content.

Module 3

Please Login or Register  to view this content.