+ Reply to Thread
Results 1 to 4 of 4

Using Values from Multiple Comboboxes to Locate information and display it.

  1. #1
    Registered User
    Join Date
    09-25-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    11

    Using Values from Multiple Comboboxes to Locate information and display it.

    Hi there, Would just like to say this forum has been invaluable to me as i am currently working on my first VBA project and hav only been using it for a few days.

    My scenario is,

    I have a Userform(estimatingtool) which contains 2 radio buttons and 3 Comboboxes. The three Comboboxes contain Selectable items (which are made from items in a database(Which someone from this forum kindl helped with))

    is there a code in which the radibox selection and the three combobx selections are used to lookup a databse and find and display the other information which is contained on the same row of the databse.

    I have attatched a copy of the workbook

    (EDIT)

    heres an easier breakdown of what i am trying to do

    1) take values from 3 seprate comboboxes and a radio button.
    2) Locate the row on the sheet "databse" which contains all of the values from the 3 comboboxes
    3) on said row there is information which i would like to be either A) copied into sheet " Estimation tool" or outputted via a user form or msgbox



    many thanks

    Jay Russ

    Dummybook.xlsm
    Last edited by Jayruss; 10-08-2012 at 11:52 AM.

  2. #2
    Registered User
    Join Date
    09-25-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Using Values from Multiple Comboboxes to Locate information and display it.

    Any Help ?

  3. #3
    Registered User
    Join Date
    09-25-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Using Values from Multiple Comboboxes to Locate information and display it.

    Is this even possible ?

  4. #4
    Registered User
    Join Date
    09-25-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Using Values from Multiple Comboboxes to Locate information and display it.

    would really appreciate any help at all

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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