Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    NY State
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can Excel automatically type in words? (Excel 2000)

    I am setting up a sheet and there are different groupings that require different formulas to be applied. My question is, is there a way to set up a macro that will type in those categories for me if I type in the first one or two letters of the word first? And can someone possibly give me a "sample" formula or "default" formula that I can reconstruct to fit my system?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Excel automatically type in words? (Excel 2000)

    I'm not sure I understand exactly what you are trying to do. Do you want the formulas to auto-complete when you are typing them in, or the "categories"? If it is the categories, what are these categories, and how many of them are there? Will there be a possibility that additional categories will have to be added, and if so how often.

    Would it be possible for you to upload a sample workbook that shows what you are trying to do? It sound like you might be able to use data validation to accomplish what you want, but I don't understand well enough to be sure.
    Legare Coleman

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Can Excel automatically type in words? (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Millie

    Yes you can use what we call Custom Lists.

    You know how when you type 1,2,3 in Cells A1,A2,A3 respectevlly and then use the Fill Handle to drag, and Excel will fill 4,5,6,7,8... as far as you go, well this is also true for Monday, Tuesday... or Mon, Tue..., or even January, February because these are months and days and they are predefined in your Custom Lists.

    So to make a custom list try the following:

    1) <font color=red> Type </font color=red> the items of the list in a range.
    2) From <font color=blue> Tools Menu </font color=blue> Choose <font color=red> Options </font color=red>
    3) Activate the <font color=red> Custom List </font color=red> tab
    4) <font color=red> Fill </font color=red> the Range in the <font color=blue> Import List from cells </font color=blue> input box.
    5) <font color=red> Click Import </font color=red>

    And you got your list.

    Now if you type the first couple of entries, and Fill down you get that list.

    Hope this helps

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Location
    NY State
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Excel automatically type in words? (Excel 2000)

    Thank You for your idea. What I ended up doing was going into my Visual Basic and making a macro for it. There is a code column and dependin gon what number is typed into the code column, the name appears automatically in the next column and corresponding row. I appreciate your response and I am sure that it will definately come in handy i te near future.

  5. #5
    New Lounger
    Join Date
    Mar 2002
    Location
    NY State
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Excel automatically type in words? (Excel 2000)

    Sorry I wasn't as clear as you may have needed me to be. What I ended up doing to solve my problem was I went into my Visual Basic and made a macro for it. There is a code column and depending on what number is typed into the code column, the name appears automatically in the corresponding column and row. I appreciate your prompt response and I will be more dtailed in my future postings.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Excel automatically type in words? (Excel 2000)

    You haven't given a lot of details, but it sounds like this did not need a macro. It could have been done using the VLOOKUP function and a table of the codes and names.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •