Auto Complete Text Excel 2007

**zrupnick** · 12-04-2009, 06:17 PM

I am new to VBA and am looking to add this code to autocomplete the text. I found this on line but it doesn't work for 2007. Thanks for any help.

Please Login or Register  to view this content.

**Paul** · 12-04-2009, 07:37 PM

Hi Zrupnick,

What, specifically, do you mean by "it doesn't work for 2007?" Does it give an error? Does it not do what you expect?

I'd suggest providing a sample worksheet, and explain what it SHOULD be doing in your eyes (as it may in Excel 2003 or earlier).

**jrdnoland** · 12-04-2009, 07:50 PM

Look at RED items. Also all this code does is activate the F2 key and all that does is edit the active cell.

Check the autocomplete setting in Excel 07
# Click on Office Button > Excel Options to bring up the Excel Options dialog box.

# Click on the Advanced button in the left hand pane.

# Remove or add the checkmark from the Enable AutoComplete for cell values option box.

# Click OK.

**zrupnick** · 12-07-2009, 10:19 AM

I have columns A & B on the worksheet as a named range and I wanted column C to autofill the names base on what was typed. I was hoping that if you started "Joseph" the macro would pick up that name from the list and autofill. Right now it does no do it. The F2 key is to add a name to the list if it does not appear. I have taken off autocomplete in the excel options and tried it and then selected it again. I was thinking I needed to add xlfillvalues to the code but I'm not really sure if that is the way to go. I have attached a spreadsheet and hopefully someone can figure it out. Thanks.