+ Reply to Thread
Results 1 to 4 of 4

Code to remove item form list box

  1. #1
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Code to remove item form list box

    Im looking for some code to remove an item from a userform list box. The list box is populated using the following code (thank you fredlo):
    Please Login or Register  to view this content.
    The user selects an item in the list box then enters data into a text box, which gets added to the record matching the selected item in the list when a command button is pressed using the following code:
    Please Login or Register  to view this content.
    When the command button is pressed I need it to also remove that entry from the list box. The code could either just remove the selected entry, or some how perform the same action carried out in the code above. I tried reusing the code above for this action, but it didn't work properly.

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Code to remove item form list box

    This would remove the selected item from the listbox.

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Re: Code to remove item form list box

    Thank you xlbiznes

  4. #4
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Code to remove item form list box

    You are welcome, glad i could help.

+ 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 an item from a validation list after selected?
    By hey_ray in forum Excel General
    Replies: 6
    Last Post: 02-23-2014, 05:18 PM
  2. [SOLVED] Not able to remove blank cells in new list keeps repeating same item?
    By omallyfoster in forum Excel General
    Replies: 2
    Last Post: 05-21-2013, 02:16 PM
  3. List box Double Click Copy and remove item
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 05:00 PM
  4. List box remove item
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2012, 02:00 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

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