+ Reply to Thread
Results 1 to 3 of 3

Populated Textbox by listbox only showing first record

  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    swindon, england
    MS-Off Ver
    Excel 2013
    Posts
    38

    Populated Textbox by listbox only showing first record

    Guys,

    only one question here.
    I did manage to get textboxes populated however when i click on second item in listbox, the info of the frist record is still standing, how can i change this. i want as soon as i click on an item the data of that item shown in the textboxes. I cant send the file into the forum because its way to big now

    Here the file in public box
    HTML Code: 

    This is in the form SearchResultForm
    Please Login or Register  to view this content.
    If anyone can help me with this
    Thanx in advance
    Infrastr Supp Spec II-III
    HP CDS Limited UK

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Populated Textbox by listbox only showing first record

    Try changing ListCount to ListIndex.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    01-29-2014
    Location
    swindon, england
    MS-Off Ver
    Excel 2013
    Posts
    38

    Re: Populated Textbox by listbox only showing first record

    Yep that did the trick

    Thanks Norie

+ 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. Not showing value time in TextBox and ListBox
    By Seeuw in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-14-2013, 06:27 AM
  2. [SOLVED] Textbox to be populated with data from another worksheet
    By saji in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2013, 07:02 AM
  3. Complex userform with user-populated listbox
    By olivierpbeland in forum Excel Programming / VBA / Macros
    Replies: 72
    Last Post: 01-23-2013, 04:18 PM
  4. Error in populated listbox userform
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2010, 09:54 PM
  5. Add Items To RowSource Populated ListBox
    By radar_jynx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2009, 10:18 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