+ Reply to Thread
Results 1 to 2 of 2

Update (strikethrough) Listbox item selected within sheet

  1. #1
    Registered User
    Join Date
    12-09-2013
    Location
    SA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Update (strikethrough) Listbox item selected within sheet

    Hi guys

    This site has helped me a lot with my VBA but I battle to find a proper solution to my issue:

    I have a userform that search for a value in column A, it displays the results in the listbox. Example: Search for value "111" and it brings me back the following results back in the listbox "111 David 35". So this means 3 columns matching data is returned.

    I want the following to happen if I double click on the item in the listbox it needs to update the value selected in the worksheet eg. strikethrough the row on the sheet to show item has been seleced/done.

    Code for my listbox populate:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Appreciate your help!

  2. #2
    Registered User
    Join Date
    12-09-2013
    Location
    SA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Update (strikethrough) Listbox item selected within sheet

    I have done this dbl click so far BUT it goes to the top and not the item selected...I know it is something STUPID!!

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Remove selected item from listbox
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-28-2014, 08:36 AM
  2. how do I return a HIGHLIGHTED (not selected) item from a ListBox?
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 08:27 AM
  3. Change status of more than one item selected in Listbox
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-29-2012, 05:09 AM
  4. Need selected item from listbox after double click
    By peterfarge@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2006, 11:20 AM
  5. How to copy selected listbox item to sheet
    By michdan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2005, 08: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1