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!

gupta.awadhesh

You can write a macro for this in Excel sheet itself... do 1thing, write a macro in the change event of the sheet in which you type your values, all that the macro will do is that the moment nething is typed in the sheet, it will pick up the typed alphabets into a variable and compare it with that of on the second sheet, if it finds a matching records then it'll replace the entire value. Ypu will also need to use to function names selstart and sellength to unhighlight the manually typped characters.

does it solve your problem???

__________________
RegardsAwadhesh