PDA

View Full Version : Autocomplete



zrupnick
12-16-2009, 07:06 PM
I tried the code from byundt posted on this site. I have excel 2007 and the autocomplete would not work. I looked at the code and not really knowing what I'm looking for, could not figure it out. I understand what its trying to do but I lack the skills to edit the code. When I tried to type a name in column A on the second sheet the macro would allow the text to be entered. I would like to be able to use the code but have had no luck.

mdmackillop
12-16-2009, 11:12 PM
Can you post the location?

zrupnick
12-17-2009, 08:00 AM
I have attached the zip file that was posted here. Thanks

geekgirlau
12-22-2009, 09:32 PM
I don't have 2003 here to run a comparison, but I'm wondering whether this is impacted by the timing of the worksheet change event.

What I'm seeing is that the event is kicked off when you finish typing in the cell, which basically makes this procedure pretty useless!

praskavi
06-13-2010, 02:55 AM
Hi,it is great to be part of this forum. I have tried the autocomplete macro,but it doesn't look like it works on Excel 2007. I am looking for autocomplete code,so that I can use rep etitive data from different columns like Sales Item code. There'smore than 300 sales item code with different revenue for each sales item.

So I need autocomplete when ever I start typing the sales item in Column and Revenue in anothercolumn. How can I achievbe this,I have been searching for answers for ages.

Aussiebear
06-13-2010, 02:44 PM
praskavi, please do not use all upper case when posting something tothe forum. I've corrected your post this time

Simon Lloyd
07-03-2010, 03:56 AM
Unrelated Poll deleted!

geekgirlau
07-06-2010, 04:04 PM
Have you considered just using a Data Validation list instead of a macro?

mdmackillop
07-07-2010, 12:38 AM
I posted on something similar here (http://www.vbaexpress.com/forum/showpost.php?p=195024&postcount=5)