+ Reply to Thread
Results 1 to 6 of 6

VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

  1. #1
    Registered User
    Join Date
    06-10-2014
    Posts
    42

    VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

    Hi experts

    i have 2 set of matching total profit from sheet (Green and Orange)

    i have userform i need vba code to execute these actions

    need to validate Drop down list that covers two correspoding columns for listbox1 and 2 for 3

    if i select region = ASIA In Listbox1 then listbox2 show all unique values towards ASIA, then
    if i select country= CHINA in Listbox2 then Llistbox3 show all unique values towards china
    in listbox3 show all Order ID ,then what Order ID select in , result should pop up in both side 3 textboxes green and oranges

    Listbox1 Unique column of B:B
    Listbox2 Unique column of C:C
    Listbox3 Unique column of A:A depends upon Order ID , Result values will be shown in 3 textbox of green and orange becoz order id reflect in both sheet

    check sheet view to understand my requirement
    click_G for userform

    Thanks and regards
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,862

    Re: VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

    Please updata your profile - Location and Excel version -as answers do depend on knowing this information
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,862

    Re: VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,501

    Re: VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

    Attached file has an alternative solution if interested ...
    Attached Files Attached Files
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  5. #5
    Registered User
    Join Date
    06-10-2014
    Posts
    42

    Re: VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

    Thanks for all experts great code experience solved!!!

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,862

    Re: VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

    Please re-read post #2 and do as requested.

+ 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. [SOLVED] Need VBA code to create sheet depends upon value select in 2 combo box list
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-06-2022, 01:19 AM
  2. [SOLVED] Filter List Box values based on multiple text boxes
    By Medex in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-09-2018, 03:17 PM
  3. [SOLVED] Values come depends on Drop Down List name
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-01-2016, 09:44 AM
  4. [SOLVED] VBA Code replace old values to new values depends upon column values
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2015, 08:19 AM
  5. [SOLVED] Fill List Box with Five Text Boxes and Put List Box on Sheet
    By AmirSoft in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-25-2014, 11:42 AM
  6. [SOLVED] code populates list boxes in active sheet, but does not populate boxes in subsequent sheet
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2014, 10:26 AM
  7. Replies: 10
    Last Post: 03-17-2013, 02:28 AM

Tags for this Thread

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