Hello everyone! I hope you all are doing well! I am very new in Excel programming/VBA, and have been given a task which I am not sure how to complete. What I need to do is to create a macro for searching through a workbook and returning a word while I start entering letters of that word in the cell.

For example, the macro should enable me to start entering a word "Market center" in a cell A1 (Sheet1), which is also located in the cell B7 of the Sheet2, and as soon as I start entering the word, for example "Ma", the list of all possible words starting with "Ma" should pop-up, eventually leaving me very few options among which would be "Market center", which now I can click to enter to the cell. Is this possible to do in Excel?

Thank you in advance for your help.