+ Reply to Thread
Results 1 to 3 of 3

Get exact values from Combo box

  1. #1
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Get exact values from Combo box

    Hi Team,

    Please go through the attached file.

    I am using the below code

    Please Login or Register  to view this content.
    but it returns 1, 2 etc, however I need exact word like "All", "General Conjoint", etc.

    Kindly help.

    Thanks
    Abdul
    Attached Files Attached Files
    Last edited by abduljaleel.mca; 08-01-2013 at 08:05 AM.

  2. #2
    Registered User
    Join Date
    05-14-2013
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2003/2010
    Posts
    17

    Re: Get exact values from Combo box

    First you need to find the box number of the drop down, you have two. Go the Home Tab > Find & Select > Selection Pane. You will find the names there.

    Now you need to pull the value...

    You can use this to pull the value:

    Please Login or Register  to view this content.
    Basically takes the number that is returned and gives you the List Value... hope that helps!

  3. #3
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Get exact values from Combo box

    Thanks, it was very helpful for me to proceed further.

    Abdul-

+ 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. Combo Box exact range of data
    By hoongz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2011, 05:31 AM
  2. Vlookup without exact values?
    By Worldtraveller in forum Excel General
    Replies: 2
    Last Post: 04-15-2011, 10:03 PM
  3. Using multiple values to locate exact values
    By jgg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2009, 06:58 AM
  4. Values of combo box dependent on selection in another combo box
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2008, 05:16 AM
  5. Lookup with EXACT values
    By Solarissf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-14-2008, 02:29 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