+ Reply to Thread
Results 1 to 7 of 7

Listbox selected row to show on label caption

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Listbox selected row to show on label caption

    Please Login or Register  to view this content.
    I thought I was reading on the microsoft help that this would work. But it seems to be doing nothing. Any suggestions on how to get that label caption to show the selected listbox row?

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Listbox selected row to show on label caption

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    11-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Listbox selected row to show on label caption

    Thank you

    This lists the index number. Is there a way to show the text on that row? Ah, now that I re read the question I did actually ask for the row to be listed. I'm sorry, I meant the text on that row.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Listbox selected row to show on label caption

    Quote Originally Posted by monkey1184 View Post
    Thank you

    This lists the index number. Is there a way to show the text on that row? Ah, now that I re read the question I did actually ask for the row to be listed. I'm sorry, I meant the text on that row.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Listbox selected row to show on label caption

    Thank you again

    This listbox has 3 columns in it. Now it shows the first column's value. Is there a way to put all three columns on the label?

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Listbox selected row to show on label caption

    Quote Originally Posted by monkey1184 View Post
    Thank you again

    This listbox has 3 columns in it. Now it shows the first column's value. Is there a way to put all three columns on the label?
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    11-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Listbox selected row to show on label caption

    Thank you very much! I was getting so off the mark trying to get this to work. And you just did it with simple code I can even understand. That's awesome, you really made my day better.

    Also I'm going to fix the specific question I asked. But this also lets me do more things I needed to do as well. Because this gives me some knowledge to move forward on other things.
    Last edited by monkey1184; 11-22-2013 at 08:08 PM.

  8. #8
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Listbox selected row to show on label caption

    You're welcome.

+ 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] Change Label Caption VB...
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2013, 09:17 AM
  2. [SOLVED] Label caption
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-25-2013, 09:31 AM
  3. New Sum and label caption not working
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2011, 11:46 AM
  4. Display label caption
    By Nancy123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2010, 07:49 AM
  5. Update label caption upon selecting Listbox item
    By munkayboi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2007, 04:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1