Hi
I can’t seem to get auto fill to work
I checked the box for>>>Enable Auto Complete for cell values check box to turn automatic completion of cell values on or off.<<<
It only works up to the first empty cell in the row. If an entry is the same above the empty cell, auto fill doesn’t work
I’m using Excel 2010
mike
That is the nature of the autocomplete feature.
You could put a space character in the empty cell(s) for it to recognize the filled cells above.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Since you posted it in the VB forum...
Do you want to have a solution like using the auto correct dictionary to autocomplete your list?
The obvious benefits and disadvantages apply there, If you are interested you can upload a representative sample of your data and I can set up a demo.
or you can look at this for another way which you can play around with.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=244
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Hi AlphaFrog,scottiex,
Thank you for your replies
Sorry I didn't get back sooner.
I have the instant notification box check but did not get any email that a response was made.
I didn't think about using a ' in the empty cells. Thanks
I will play around with the code and see if it will work for me. I don't have time till next week.
I'll come back with questions(which I know I will have) I'm sort of a novice with macros
mike
Hi scottiex,
I had time to try your code.
I can't get it to work
I opened a new book
I named Sheet1 >>Source data<<<
I ranged name B:B: to >>AutoCompleteText<<<
I put your macro in Sheet1(Source data)
I checked the spelling (I'm prone to mistakes !!!!)
I used f5 to go the the range to make sure it was there)
I put in some words in B1:B3
When I typed in the same words in A4:A6, Autofill did not complete the words till I hit enter.
I'll check back in a couple of days if instant notice doesn't work
thank you
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks