+ Reply to Thread
Results 1 to 4 of 4

Searchable DropdownList using Combo Box

  1. #1
    Registered User
    Join Date
    01-19-2019
    Location
    Colombo,Sri Lanka
    MS-Off Ver
    office365
    Posts
    2

    Post Searchable DropdownList using Combo Box

    Hi.

    I created a searchable dropdown using a combo box. The dropdown works fine. But when I clicked on other cells, the data in the combo box comes out.


    Please advise.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Searchable DropdownList using Combo Box

    the data in the combo box comes out
    What does this mean ??
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    01-19-2019
    Location
    Colombo,Sri Lanka
    MS-Off Ver
    office365
    Posts
    2
    Quote Originally Posted by bakerman2 View Post
    What does this mean ??
    I created the searchable dropdown using a combo box & a VBA code.dropdown works fine.but when i click on other cells in the same sheet,the data selected using the dropdown,displays outside the dropdown(box)

  4. #4
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Searchable DropdownList using Combo Box

    Please advise.
    There is nothing to advice without example and code.
    Click the * Add Reputation below to say thanks.

+ 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. Searchable Dropdowns Combo Box
    By nat90 in forum Excel General
    Replies: 3
    Last Post: 12-07-2018, 04:01 PM
  2. [SOLVED] Can't seem to ''='' a cell which is a dropdownlist
    By The excel apprentice in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-06-2016, 08:40 AM
  3. Combo Box - Drop Down searchable drop down.
    By srini_tbcl in forum Excel General
    Replies: 0
    Last Post: 09-19-2014, 08:26 AM
  4. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  5. Replies: 1
    Last Post: 11-29-2012, 09:58 AM
  6. combo box with specify data dropdownlist
    By herukuncahyono in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2009, 10:40 PM
  7. Dropdownlist in a Cell
    By Lasse Matsson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2005, 04: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