Results 1 to 3 of 3

How to get row number of selected item of list box with duplicates?

Threaded View

ImranBhatti How to get row number of... 03-15-2017, 02:33 AM
mike7952 Re: How to get row number of... 03-15-2017, 06:51 AM
MickG Re: How to get row number of... 03-15-2017, 07:37 AM
  1. 03-15-2017, 02:33 AM #1
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    How to get row number of selected item of list box with duplicates?

    Hello

    I am not sure how to get the row number of selected item of listbox if there are duplicates in the list?
    in the attached workbook.I want to select the item in the listbox and the item on the worksheet should be highlighted in the same order based on the row number but it does't due to duplicates.
    Thoughts?

    Best Regards
    Imran Bhatti
    Attached Files Attached Files
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Active X drop down list - always return to the item in the list that was selected.
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-14-2017, 09:41 AM
  2. Pulling an entire row of data from an item list by entering just the item number
    By Al Douglas in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-22-2014, 12:27 AM
  3. [SOLVED] Using an IF formula from a selected item from a list?
    By slaughtontdc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2013, 05:55 AM
  4. How do I set worksheet to auto input number when item selected from dropdown list.
    By computerjen in forum Excel General
    Replies: 2
    Last Post: 12-06-2012, 05:52 PM
  5. [SOLVED] Average only the 1st item when there are duplicates in a list
    By JungleJme in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 06:18 AM
  6. getting value of selected list item in a textarea
    By junoon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2006, 10:55 PM
  7. Last list item selected in a Multi-Select list box?
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2005, 05:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1