Hello EveryOne!
I have a UserForm with two ComboBox’s (name ComboBox1 and ComboBox2) and a ListBox (name ListBox1).
In UserFrom “ComboBox1” shows two options of months “January” and “February”.
And ComboBox2 shows options “Advertising”, “Bills” ,”Daily Expenses”
I have some Data on my Excel Sheet. I want to pull that Data and show it in UserForm according to their Month in which they are incurred.
For Example If from Userform “January” month is selected and “Advertising” is selected then it should show data in the ListBox1 as follow.
1-Jan-14 January Advertising TV 100
5-Jan-14 January Advertising Newspaper 30
5-Feb-14 January Advertising Internet 30
I have attached UserForm and Excel Sheet.
I hope you guys will be understanding what I mean.
Please help, I would be very thankful.
Regards
z-eighty2
Bookmarks