Results 1 to 8 of 8

Displaying item from a listbox in a textbox with next 2 columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-15-2012
    Location
    Jamaica
    MS-Off Ver
    Microsoft 365
    Posts
    244

    Displaying item from a listbox in a textbox with next 2 columns

    Hello

    I have a listbox (listbox5), the source of the listbox is range "a5:a10". Is it possible that when i click on an item in the listbox, can I use a command click event from a button to display the item in a textbox along with the information in the same row up to column "C".

    So to simplify, the row source is "a5:a10", if the item i selcetd in the listbox is at "a6", then i want the textbox to display "A6:C6" via click event from command button
    Last edited by kmakjop; 06-25-2014 at 12:49 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display Selected Item in Listbox in Textbox
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-14-2014, 04:19 PM
  2. [SOLVED] Displaying last 5 value of an excel column to a textbox or listbox
    By nathan0519 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2014, 02:27 AM
  3. Select listbox item then appear textbox
    By sohaila in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 04:41 AM
  4. [SOLVED] Displaying data from different columns in listbox
    By pezalmendra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2012, 05:47 PM
  5. Retaining focus on a textbox / listbox item pair after validation = false.
    By chatterbox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2006, 06:50 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