+ Reply to Thread
Results 1 to 4 of 4

Search as you type box + autopopulate cells

  1. #1
    Registered User
    Join Date
    01-17-2017
    Location
    France
    MS-Off Ver
    2010
    Posts
    3

    Search as you type box + autopopulate cells

    Hi,

    I read countless thread about what i want to do but cannot manage to get it working so if someone would be so kind to help me out i would be grateful.

    A colleague asked me to write him a spreadsheet that is easier/smarter to use and could aggregate all of the required field of several other documents. (Those are Internet Provider Order document). Some of those information are available in a database and some needs to be filled manually.

    So i imported in a spreadsheet our locations database (~7k entities) with several column header : A to V in fact, so 22 columns (Site code, address, Provider, Phone number etc).

    I would like have a textbox / ComboBox on a spreadsheet (The First one, in fact) to search as you type this array (Not needed to search ALL of the column, only site code, ZIP Code, address and phone numer should be enough) and would autopopulate cells below the box with the cells information of the selected row when selected, and not just copy the entire row so i can make some display change, like selected field from column A would go to cell X on the first sheet, column B to cell Y etc

    This way i could just take those cells + manually filled one and export them to the real command order and the user just have to click "generate" and the real command order pop-up already filled and he just sign, save & send. (This part i'm fine with, open another Workboot and copy value from cell to cell is easy enough for me...). We have 3 different providers and this would be used by newcomer because it would be easier to use (Autofill with the information we have, and just the required field are displayed instead of several sheets and not needed cells on the real command order.

    Hoping that my explanations are understandable.

    Sorry for my bad english and thanks in advance !

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Search as you type box + autopopulate cells

    You can autofilter as you type,
    http://www.xlorate.com/excel-questio...s%20you%20Type
    https://www.youtube.com/watch?v=E6Nj2vIvlpI

  3. #3
    Registered User
    Join Date
    01-17-2017
    Location
    France
    MS-Off Ver
    2010
    Posts
    3

    Re: Search as you type box + autopopulate cells

    Quote Originally Posted by davesexcel View Post
    Thanks for the answers, it's working as intended expect that i cannot use that, i do not want to filter my array but filter the selection range of the combo/text box to be able to select it.

    And i tried, filtering the array work (The rows are hidden) but it has no effect on the box selection (which still display 7k+ rows) on the first sheet.

  4. #4
    Registered User
    Join Date
    01-17-2017
    Location
    France
    MS-Off Ver
    2010
    Posts
    3

    Re: Search as you type box + autopopulate cells

    I do not want to filter my array All that does is hide the non matching rows, which has no effect on a selection textbox/combobox. I suppose i could filter the box by adding a "hidden = false" into the vba of the combo box, but then users would have to go to the array sheet to search and come back to the first sheet to continue their input.
    Last edited by JBeaucaire; 02-28-2017 at 01:39 PM.

+ 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. [SOLVED] Autopopulate macro, needs to searrch for appropriate section to autopopulate
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-09-2015, 09:11 AM
  2. [SOLVED] userform search button remove search only when i type
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2014, 02:32 AM
  3. [SOLVED] Autopopulate Cells
    By toadly in forum Excel General
    Replies: 4
    Last Post: 12-10-2013, 12:39 PM
  4. Search for a value and autopopulate the next 2 cells.
    By Hawkdriver in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2013, 07:15 AM
  5. Replies: 0
    Last Post: 09-05-2011, 05:32 AM
  6. search with autopopulate
    By mrchip in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2011, 12:49 PM
  7. how to autopopulate cells based on values from other cells
    By marbie in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-28-2011, 05:31 AM

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