+ Reply to Thread
Results 1 to 2 of 2

How to type in the abbrev and autofill the cell ?

  1. #1
    Forum Contributor
    Join Date
    08-01-2016
    Location
    China, beijing
    MS-Off Ver
    2016
    Posts
    114

    How to type in the abbrev and autofill the cell ?

    Here is the thing. Every day I need to type in the goods type so many like "AB220", "AC230" and so on. So I don't want to input that so many time. So I want to use the abbrev to make that. For example I just type the "2", "2" and "enter" the cell will show the AB220.

    I know that there is a mechanism in the Excel that if you enter "AB" the AB220 will show out. But that need to input the head character of a word, which not meet my requirement. So how to fix that ?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: How to type in the abbrev and autofill the cell ?

    The only way to do what you want is with VBA
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 0
    Last Post: 02-04-2015, 03:46 PM
  2. Autofill base on Active Cell and Autofill by row count of another sheet
    By enyak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2014, 10:06 PM
  3. Autofill a form - (complicated) Based on person, type of event
    By aequitas19 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2012, 10:59 AM
  4. Autofill from a list as i type in the same cell
    By jwcullen85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2012, 10:25 AM
  5. 'Type mismatch' error with autofill and VBA
    By The Mekon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2008, 04:41 PM
  6. Autofill "fill as you type" Lookups
    By MKAH in forum Excel General
    Replies: 5
    Last Post: 01-28-2007, 12:44 PM
  7. Autofill type feature.
    By brookdale in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2005, 05:47 PM

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