+ Reply to Thread
Results 1 to 1 of 1

UserForm: Search Item in List > Call Table associated with Item > Execute Command

  1. #1
    Registered User
    Join Date
    02-24-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    4

    UserForm: Search Item in List > Call Table associated with Item > Execute Command

    Continuation from: http://www.excelforum.com/excel-prog...bobox-1-a.html



    I am up against a rather difficult challenge but I would like to see if you can help me out.


    Background:

    ** Example **
    UserForm Interface:
    ComboBox1 = Department #1
    ComboBox2 = PumpA1


    The tricky part is that each Pump (dependent on Department #) has a Data Table associated with it. The Dimensions of each table vary depending upon Failure Data history.


    Goal: (Execute Command)

    I need a code which will take the Values of ComboBox1 and ComboBox2, and run a Pump Search in the appropriate Department # "Failure History Data" sheet, and generate the Defined Table in a "Results" Sheet


    I have a picture which shows a portion of the tables that are associated with each Pump.PumpFailure Data.jpg


    Let me know if you understand what I am trying to do here, or if you need me to formalize this a bit more.


    As always, thanks.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,597

    Re: UserForm: Search Item in List > Call Table associated with Item > Execute Command

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    02-24-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: UserForm: Search Item in List > Call Table associated with Item > Execute Command

    Sample Worksheet.xlsm


    On the Interface, only Department 30 AN2 works. I deleted a lot of other stuff that doesnt pertain to this problem (for simplicity).


    Thanks!

  4. #4
    Registered User
    Join Date
    02-24-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: UserForm: Search Item in List > Call Table associated with Item > Execute Command

    The Code that is currently in the "ExecuteCommandButton Sub" is from another example that I was trying to work through, it is not correct.

    Also, I defined names for every table associated with each pump. Though it was very tedious, I was hoping this would provide an easier way to call the correct table depending upon the selection made from the UserForm Interface.

    I would like the Pump Failure Data table placed in the Failure History sheet as the result to the Execute command button.


    Let me know if you need more clarification.

+ 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. Help with VBA, find Item from list then sum totals of each item by type
    By HR_GUY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2013, 01:30 PM
  2. Replies: 2
    Last Post: 02-29-2012, 03:57 AM
  3. Taking the next item in a list into 1 of 2 tables based on the previous item time
    By SoleAris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2011, 04:59 PM
  4. userform to search exist data customer item list for make bill
    By shaik.ibrahim in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2011, 04:37 AM
  5. linking a list item or text item in a user form to a worksheet
    By ravergirl7216 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-03-2010, 03:43 AM

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