Results 1 to 2 of 2

Thread: Excel Macros: AutoComplete?

  1. Apr 7th, 2006, 11:11 AM #1
    mr_fubar2818
    mr_fubar2818 is offline

    Thread Starter
    New Member
    Join Date
    Apr 2006
    Posts
    1

    Excel Macros: AutoComplete?

    Hey everyone! I'm new to VB, so bear with me on this, hehe.

    I'm trying to make an Excel sheet where you can start typing in one cell and have it autocomplete what you are typing by using a group of data on a different worksheet, and I can't figure out how to do this. So for example, say I have a list with values January, February, etc. going from A1 - A12 in a grouped list on worksheet 2. I want to be able to start typing "Jan" in cell A1 on worksheet 1 and have Excel autocomplete what I'm typing once it finds a compatible match in the group. I'm starting to wonder if this is even possible in Excel? I've been looking around in the object properties in VB and I'm seeing an AutoComplete property, but I'm not sure how to use it, or if it is even going to work with what I'm looking for. Can anyone help me out with this? Thanks!
    Reply With Quote Reply With Quote
  2. Apr 7th, 2006, 11:48 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Excel Macros: AutoComplete?

    Excel VBA question moved to Office Development
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width