autocomplete

Hi, the title probably doesn't explain what I need to do, so I have two sheets, SHEET1 and SHEET2. SHEET1 holds a list of variables which can sometimes be added to SHEET2. SHEET2 therefore holds some variables from SHEET1 and its' own variables also. I will explain this more Consider SHEET1...

Hi All, Although this is my first post on here.. Thank You to the Forum as I've been following and learning on here for over a year now. As per my subject title, I have quite a few things I'm trying to work on and they are all linked to the Active X Combo Box. I'm running Windows 7 and Excel...

Greetings All, Excel Question, I am building a worksheet using data validation from a list on a separate tab. Column 1 contains key categories entries and Column 2 contains the subcategories related to Column 1's entry. So, if someone selects "Software problems" in the 1st drop-down list there...

I use validated drop-down lists quite often with lists of up to 50 items. I am working on a project with one drop-down list linked to a named range containing nearly 500 items. Since there are so many items, I wanted to use AutoComplete. I found this code from the fine folks at Contextures...

I put together about 10 separate macros that will log you into a site using the values in a given cell. I was having trouble with the last one because of AutoComplete remembering the username. So I put in an IF statement, and when I used F8 to go line for line, it works perfectly. However, when...

Within the Excel 2007 Visual Basic Editor, when I declare a variable as a Worksheet object and then, within a subroutine, set that variable to point to a worksheet object, if I start typing the code 'ws.', Excel crashes. Normally upon typing the . after ws, I would expect the Visual Basic...

Hi everybody I've already posted this in another thread, but to no avail.. My Formula is the following: =IF(E6<2863;DGET('Eingangsprüfung alte Nr.'!$A$2:$C$400;3;R6:R7);DGET(Eingangsprüfung!$A$2:$C$60000;3;R6:R7)) If I use autofill now to complete a table with approx. 3000 entries, it...

I use Excel 2007 and tried creating Auto Complete combo boxes using the example shown here http://www.contextures.com/xlDataVal10.html. Now in the example if i type "ju" and click on the drop down I should have the value "june" selected but that does not happen but according to the example this...

Is it possible to "Autocomplete" a Vendors name in an excel cell from an Access Database of vendors and then perform a vlookup from the database for contact name, address, phone, email, etc.... in adjacent cells? For example if I begin typing "Acc" then I automatically get a list of vendors...

I've looked for the answer to this but not really seeing it. Seems like every related topic I see discusses how to use autocomplete with one document. I get that. And I use it but that only works once you've already typed that word once in the document, right? Can I have Excel remember words...

Hi All, I have this query regarding UDF. I have created sum UDFs for my routine work. As you know when we start typing a function in a cell, excel (2007/2010) suggests a list of possible functions and then we select with arrow keys and hit tab to autocomplete upto the open parenthesis. now...

I was wondering if there was any way to expand on using “Data Validation with a ComboBox using Named Ranges" (taken from www.contextures.com/xlDataVal11.html) and using a Dynamic Named Range where you can add items to the drop-down list if it isn’t already in the list. Say, for example, instead...

Hi, I am stuck in a middle of a major problem which is hampering my progress. My problem is there is a text box in my company's web page that has the autocomplete option enabled. But whenever I tried to input a value in it by the way of excel programming (VBA), it doesn't provide me the...

Hello I have a bunch of useful xl files for an ongoing event i help to manage. It basically enables us to count contributions, deduct expenses, and so on. However, I would like to link this to a database of members, and the first step, once the membership list is completed, is to be able to...

Hello everyone, Is it possible for autocomplete to recognize items in other worksheets within your excel document and then present them as an option in the drop down? Thanks in advance for your help.

Hey, I have a sheet with a blank row between entries, but many of the entries are the same (Customer/Destination/etc). I would like these entries to autocomplete as if they weren't separated. eg. Entry1 | Entry2 | Entry3 | Entry2 Where "Entry2" should autocomplete...

Hi, I am currently working on a small library inventory. I have about 1100 items typed in. I realized that the auto-complete does not show me all the options. For example, there are four items that starts with "Iceland," but when I type in "i" excel shows me only one option. I know it's not a...