autocomplete

  1. J

    Code works in Debug mode but will not run through when played

    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...
  2. A

    Visual Basic Editor Autocomplete Crash

    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...
  3. P

    How to skip numbers with autocomplete?

    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...
  4. S

    Creating Autocomplete Comboboxes with dynamic lists

    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...
  5. E

    Autocomplete Vendor Name in Excel from an Access Database

    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...
  6. C

    How make excel remember words you commonly use from one document to next?

    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...
  7. S

    UDF autocomplete in excel

    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...
  8. M

    Data Validation with a ComboBox with AutoFill/AutoComplete

    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...
  9. P

    Autocomplete in a webedit(text box)

    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...
  10. O

    Help for a clueless newcomer

    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...
  11. N

    Autocomplete

    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.
  12. sir_smee

    Autocomplete over blank row

    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...
  13. T

    Auto-complete not showing all the option

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top