+ Reply to Thread
Results 1 to 4 of 4

Highlight last item in list box

  1. 07-14-2018, 10:59 PM #1
    Nitefox
    Nitefox is offline
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Highlight last item in list box

    How can I set a list box to highlight/select the last item rather than the first item in the list?
    The name of the list box is SerialNumber
    Last edited by Nitefox; 07-14-2018 at 11:02 PM.
    Reply With QuoteRegister To Reply
  2. 07-14-2018, 11:46 PM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Highlight last item in list box

    .
    This is one way :

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 07-15-2018, 12:22 AM #3
    Nitefox
    Nitefox is offline
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Re: Highlight last item in list box

    That code keeps crashing excel for some reason.
    Reply With QuoteRegister To Reply
  4. 07-15-2018, 12:31 AM #4
    Nitefox
    Nitefox is offline
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Re: Highlight last item in list box

    Found some code that works for me:
    Please Login or Register  to view this content.
    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. Pulling an entire row of data from an item list by entering just the item number
    By Al Douglas in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-22-2014, 12:27 AM
  2. UserForm: Search Item in List > Call Table associated with Item > Execute Command
    By TexasAggie12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2014, 12:58 PM
  3. Help with VBA, find Item from list then sum totals of each item by type
    By HR_GUY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2013, 01:30 PM
  4. Taking the next item in a list into 1 of 2 tables based on the previous item time
    By SoleAris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2011, 04:59 PM
  5. linking a list item or text item in a user form to a worksheet
    By ravergirl7216 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-03-2010, 03:43 AM
  6. Highlight item not in Valid List
    By smalltime in forum Excel General
    Replies: 2
    Last Post: 09-24-2009, 10:01 PM
  7. [SOLVED] list box item highlight
    By MichelleDuquette in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1