Results 1 to 6 of 6

Data not showing from Combo Box

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    332

    Data not showing from Combo Box

    Hello friends........yesterday i post a problem in forum and i did not fully describe the problem what i want.......so i again post today with brief explanation

    i attached a Test file of excel with problem

    in the file it contains two i.e. Sheet1 and Sheet2

    I create a Searchable Combo box in sheet1.........

    In sheet2 contain (3 Column) Account Number, Name of Account Holder and Rupees

    In the Account Number (Column) it have 4 accounts number.........but C7 and C9 are the same account number but names are different in "Name of Account Holder" Column.............

    My combo box is searchable please enter the account number 1234

    Now the problem is in Sheet1 when i insert the account number in Combo box i.e. 1234........it shows 1234 two times (i mean to say that choose 1234 or 1234 above or below) but on account number 1234 it have 2 different name i.e. RAZ and RITA in Sheet2..........

    I want when i enter the account number 1234 in combo box.......it gives me two (1234 and 1234) accounts number for choose..........
    i want when i choose first 1234 it show the record of RAZ
    and when i choose second 1234 it show the record of RITA

    This is the problem and how to solve this............
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combo box not showing full list
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-15-2015, 03:15 PM
  2. items in drop down lists in excel combo box not showing
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-03-2014, 03:45 PM
  3. [SOLVED] Combo Box additions not showing until after Userform closes and is reopened.
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 12-20-2012, 03:18 PM
  4. [SOLVED] Showing Combo Box Numerical Results as Text.
    By LaubeIT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2012, 11:48 AM
  5. showing drop down list when combo box is activated
    By dhavanchopra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2007, 07:49 AM
  6. [SOLVED] combo box not showing selected item..
    By nycdon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2005, 02:05 PM
  7. Showing ranges using a combo-box
    By doltish in forum Excel General
    Replies: 2
    Last Post: 07-18-2005, 02:05 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