+ Reply to Thread
Results 1 to 5 of 5

if combobox1.value match then row data show in listbox

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    if combobox1.value match then row data show in listbox

    hi, everyone
    i am using combobox1.value to pass out data to sheets("OF BC").

    i want , If combobox1.value match data from sheets("OL BC"), then data of column "H" show in listbox

    like
    combobox1.value = "anees g" then search on SHEETS("OL BC") IN RANGE("C4:C10"), If value found then show data in listbox of column H



    combobox1.value = "anees g" then lisbox1.value = "11 BC DDD"


    thanx
    sample attached
    Attached Files Attached Files
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: if combobox1.value match then row data show in listbox

    Hi, try this code
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: if combobox1.value match then row data show in listbox

    Hi, kasan
    thanx for the reply

    actually when i select new value in combobox1 then clear the listbox1 and update it when i input new value in combobox1
    for example
    i select in combobox1 = "anees g"
    then listbox1.value = "11 BC DDD" only one value


    if i select in combobx1 = "TOFEEQ KP"

    then listbox1.value = "15 BC DDD" just one value at a time


    btw very thanx

  4. #4
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: if combobox1.value match then row data show in listbox

    Ouh, my bad.
    Add this line at the beginning of the code

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: if combobox1.value match then row data show in listbox

    Perfect

    thanx kasan dear

+ 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] VBA code to show updated data in the listbox after the data is entered and button clicked
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-25-2015, 04:23 AM
  2. [SOLVED] Add two Dynamic Named Ranges in userform combobox1. Show values on label1 from combobox se
    By svgopalareddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2015, 10:54 AM
  3. How to match data from worksheet and show it in ListBox?
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2014, 02:41 AM
  4. UserFrom Match, Find and Edit data : ComboBox1 Change range
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 09:06 AM
  5. listbox of combobox2 depends on value choosen from listbox of combobox1
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-30-2013, 12:11 PM
  6. [SOLVED] If ComboBox1 = Text Then Show List name in TextBox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2013, 03:36 PM
  7. [SOLVED] Show data from textbox in a listbox using VBA
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2013, 11:04 AM

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