+ Reply to Thread
Results 1 to 1 of 1

How to pull Data from Excel Sheet and show it in UserForm?

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    pakistan
    MS-Off Ver
    Excel 2007
    Posts
    89

    How to pull Data from Excel Sheet and show it in UserForm?

    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
    Attached Files Attached Files
    Last edited by z-eighty2; 01-28-2014 at 04:38 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel userform pull data from closed workbook
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2013, 01:53 PM
  2. [SOLVED] EXCEL USERFORM- pull data from sheet 1 into userform
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 11:10 AM
  3. [SOLVED] Pull Data from once excel sheet to another
    By dt_org in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-06-2013, 12:43 AM
  4. Show data from a selected row in an excel userform
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 08-20-2012, 03:17 PM
  5. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1