+ Reply to Thread
Results 1 to 3 of 3

Removing Item from ComboBox on CommandButton Click

  1. #1
    Registered User
    Join Date
    05-15-2015
    Location
    United States
    MS-Off Ver
    2015
    Posts
    2

    Unhappy Removing Item from ComboBox on CommandButton Click

    Capture.JPG

    Hi!

    I am attempting to remove an item from a ComboBox after adding to a listbox via commandbutton.


    I have attached a picture as reference.
    ComboBox3 refers to Project
    ComboBox1 refers to GPA (A or B)

    After a project and classification have been added to the list, I want to remove that project from the ComboBox to prevent someone from double classifying.

    The code I have tried is
    Please Login or Register  to view this content.
    Because the ComboBox is always changing I can't remove an item based on the Value with this code. It ends up removing the position instead of the actual matching value. I'm guessing this could be done in a for loop where it loops through the length of the combobox array and removes the matching value but I'm not sure how to do that.

    Any thoughts?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Removing Item from ComboBox on CommandButton Click

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    05-15-2015
    Location
    United States
    MS-Off Ver
    2015
    Posts
    2

    Re: Removing Item from ComboBox on CommandButton Click

    thank you!! that did the trick!

+ 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. A macro to right click a cell and select a item from the right click menu?
    By Peavey in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2014, 10:55 AM
  2. [SOLVED] 5 ComboBox's .... 1 CommandButton ?
    By dannac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2012, 10:48 AM
  3. Call procedure when I click any commandbutton
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2012, 04:33 AM
  4. Combobox - can't get click event to run for first item in the list
    By Dale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2006, 10:00 PM
  5. Pivot Item: removing non-existant item from the drop down
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2006, 04:50 PM

Tags for this Thread

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