A
Anne
Hello, I am very new in Visual basic Excel, and have been given a task which I am not sure how to complete. What I need to do is to create a macro forsearching 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 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?
For example, the macro should enable me to start entering a word "Market center" in a cell A1 (Sheet1), which is 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?