+ Reply to Thread
Results 1 to 3 of 3

ComboBox List Display 1 item at first click

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    29

    ComboBox List Display 1 item at first click

    anyone help me to solve the tiny problem of ComboBox List

    if ComboBox List Contain 1 to 30 items and i click for first time it display 1 item only
    click anywhere for deselect the combobox and
    again click the List is full 1 to 30

    why it not display the full list


    see the attachments for more info.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: ComboBox List Display 1 item at first click

    Managed to get it running the first time round by using the DropButtonClick event instead of the GotFocus event.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: ComboBox List Display 1 item at first click

    Have you tried putting you routine in the Worksheet_Activate event?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. Removing Item from ComboBox on CommandButton Click
    By hollyeva in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2015, 11:06 PM
  2. Choose more than one Item from a Combobox/Drop List
    By Michelle_En in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2012, 03:50 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. How to load a one-item list to a ComboBox
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-13-2010, 06:30 PM
  5. Select combobox item, display wksheet name in listbox
    By ACOM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2009, 05:31 PM
  6. [SOLVED] 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
  7. [SOLVED] combobox list item with superscript
    By boyze in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2006, 01:15 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