mr_fubar2818

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!