Macro for autocomplete

[esenko]

Hi,

1) The list of names on the sheet2.
2) When enter first letters in Column A macro has to show autocomplete in cell on the sheet1.

You may find example as attachment.

[Logit]

Here is a link that describes what you want without using VBA. http://www.ozgrid.com/Excel/autocomplete-validation.htm

Now .... I have Excel 2007 .. so I can't help you find the setting in Excel 2016 but it must be there somewhere.

In 2007 it is located : Excel Options (Upper Left) / Advanced / Editing Options (select check box "Enable AutoComplete for cell values"


Thanks for asking this question, it is a 'tool' I wasn't aware of with the information included in the URL link above.

[alansidman]

The procedure described by Logit is the same for Excel 2016

[esenko]

Thanx for reply.

I don't have possibility to paste values above on the sheet1.
It should be some macro decision.

[shg]

There's an add-in at https://app.box.com/shared/ono8ni9xvr that will do that, a ReadMe at https://app.box.com/shared/4qxybepxxr, and an example workbook at https://app.box.com/shared/e8dbbple34

[scottiex]

Or you could make it change automatically to the full name when you enter the short codes by adding them to the auto correct dictionary when opening the file and removing them on closing the file

I think the below should do it, if you create a list of the things to auto correct in a sheet called autoC in column A an the things to correct to in column b. (starting from row 2 to allow for a header row)

Please Login or Register  to view this content.

[esenko]

There's an add-in at https://app.box.com/shared/ono8ni9xvr that will do that, a ReadMe at https://app.box.com/shared/4qxybepxxr, and an example workbook at https://app.box.com/shared/e8dbbple34

Thank you. It's working.
But I really need macro for this task.

[esenko]

Or you could make it change automatically to the full name when you enter the short codes by adding them to the auto correct dictionary when opening the file and removing them on closing the file

I think the below should do it, if you create a list of the things to auto correct in a sheet called autoC in column A an the things to correct to in column b. (starting from row 2 to allow for a header row)

Please Login or Register  to view this content.

I tried to do this but no actions in file.
Would you please check the attachment?
https://app.box.com/s/ngmdwt6fqo9q7y44nv0mb2qh30v3ufl3

[scottiex]

Something like this.
Keep in mind the limitations that it only corrects when you type the exact thing in the column A and while that sheet is open it will effect other sheets because we have changed the auto correct dictionary for excel.

Otherwise if you prefer shg's solution you could bring that code into your own workbook.

[scottiex]

I had a little problem with workbook open not running it (maybe someone here can advise why). So here it is with some worksheet activate events and some buttons.

You should also give moving shg's code over to a xlsm file a go as well. it doesn't have to be an add-in as it looks like he hasn't locked it down.