+ Reply to Thread
Results 1 to 5 of 5

vba coding to bring account name for a code for a drop down list

  1. 03-10-2018, 09:28 AM #1
    srinivasan1965
    srinivasan1965 is offline
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    vba coding to bring account name for a code for a drop down list

    HI
    I need a help from you to bring account name for a code through validation drop down list
    can you please help
    Thanks
    Srinivasan
    eg file is attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-10-2018, 09:37 AM #2
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: vba coding to bring account name for a code for a drop down list

    In cell B2 this formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Value in B2 will change every time A2 changes
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear
    Reply With QuoteRegister To Reply
  3. 03-10-2018, 11:17 AM #3
    srinivasan1965
    srinivasan1965 is offline
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: vba coding to bring account name for a code for a drop down list

    Thanks a lot
    is there any vba coding to get for reference any n number of cell range
    Thanks
    Srinivasan
    Reply With QuoteRegister To Reply
  4. 03-10-2018, 01:44 PM #4
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: vba coding to bring account name for a code for a drop down list

    Is this what you want?
    Test in attached workbook
    - (on sheet Data) select item from dropdown in column A and name appears in column B

    The code is in the sheet module
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-10-2018, 02:25 PM #5
    srinivasan1965
    srinivasan1965 is offline
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: vba coding to bring account name for a code for a drop down list

    Hi
    Thanks a lot This is what i wanted Many thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. How do I bring up a whole row w/ merged cells using Vlookup + drop down list
    By mahfuz_fuzion in forum Excel General
    Replies: 1
    Last Post: 11-06-2017, 11:43 AM
  2. [SOLVED] Drop down list and bring in additional data
    By ROTHERS in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-18-2014, 06:37 AM
  3. [SOLVED] Color Coding in a Drop Down List
    By Don in forum Excel General
    Replies: 6
    Last Post: 10-06-2012, 04:00 AM
  4. [SOLVED] Using a drop down list to bring back data appropriate to the date selected
    By mjk336 in forum Excel General
    Replies: 2
    Last Post: 06-29-2012, 10:29 AM
  5. Drop Down List To Bring Column Data to Current Worksheet
    By Doogster in forum Excel General
    Replies: 7
    Last Post: 05-15-2012, 03:41 PM
  6. Excel 2007 : Color Coding Selections in a Drop Down List
    By aggies75 in forum Excel General
    Replies: 0
    Last Post: 10-28-2011, 10:22 AM
  7. validation list drop down box, how do I bring in text commands
    By Scott in forum Excel General
    Replies: 1
    Last Post: 09-29-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1