+ Reply to Thread
Results 1 to 3 of 3

Clear ComboBox Selection

  1. #1
    Forum Contributor
    Join Date
    04-23-2012
    Location
    Bradford PA
    MS-Off Ver
    Excel 2010
    Posts
    250

    Clear ComboBox Selection

    I use a Shape Click to stimulate a population of combobox then use the combobox selection to take user to worksheet. Problem: The combobox does not clear after selection so it keeps compounding the same results:

    Shape Code:
    Please Login or Register  to view this content.
    ComboBox Code:

    Please Login or Register  to view this content.
    Thanks in advance for any help

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Clear ComboBox Selection

    Hi jared,

    I'm not sure if I completely understand your problem, other than the list replicating itself each time you do a 'Dashboard9_Click'. The following clears the combobox immediately after the 'Dashboard9_Click' (and inhibits an Event from being triggered by the Clear).

    Try the following (tested and working using Excel 2003).


    Shape Code:
    Please Login or Register  to view this content.

    ComboBox Code:
    Please Login or Register  to view this content.
    Please note that the 'iGblInhibit' technique is very useful in preventing unwanted events from specific controls.

    Lewis

  3. #3
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Clear ComboBox Selection

    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

+ 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. Userform Combobox to populate based on selection in another combobox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 03:34 PM
  2. [SOLVED] Filter Combobox base on selection from previous combobox
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2013, 07:25 PM
  3. [SOLVED] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  4. [SOLVED] fill combobox selection based on a selection from the first combobox
    By Monza in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 07:34 PM
  5. clear combobox selection
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2007, 10:16 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