How to pull Data from Excel Sheet and show it in UserForm?
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.
Last edited by z-eighty2; 01-28-2014 at 04:38 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By thameem127 in forum Excel Programming / VBA / Macros
Last Post: 05-23-2013, 01:53 PM
By PANTECH in forum Excel Programming / VBA / Macros
Last Post: 04-18-2013, 11:10 AM
By dt_org in forum Excel Formulas & Functions
Last Post: 01-06-2013, 12:43 AM
By Megatronixs in forum Excel Programming / VBA / Macros
Last Post: 08-20-2012, 03:17 PM
By egemenkepekci in forum Excel Programming / VBA / Macros
Last Post: 05-25-2010, 01:06 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1