You can’t. The code engine won’t run while Excel is in Edit mode. You have to have the user enter the text in something other than a cell – like a control on the worksheet or a control on a userform.
More Related Contents:
- delete Autofilter Field resullt using the header Name
- Somehow it’s not copying [closed]
- VBA macro that search for file in multiple subfolders
- So, I have 6 “master” files to then divide into 40 separate files
- Getting ScriptControl to work with Excel 2010 x64
- Application.Match gives type mismatch
- Transpose a range in VBA
- Protecting cells in Excel but allow these to be modified by VBA script
- Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
- Using VBA code, how to export Excel worksheets as image in Excel 2003?
- How to add a DocumentProperty to CustomDocumentProperties in Excel?
- How do I name a spreadsheet automatically, by referencing two cells?
- Excel VBA Delete Rows
- VBA: How to delete filtered rows in Excel?
- Determine whether user is adding or deleting rows
- How to use VBA SaveAs without closing calling workbook?
- Removing special characters VBA Excel
- Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
- Iterate over slicer via VBA and select a single item each time
- Loop through Excel Sheets
- Return a range from A1 to the true last used cell
- How to add items to a combobox in a form in excel VBA?
- How can I open this VBA workbook faster?
- How can I automate Save as dialog box in IE11 using VBA?
- How do I avoid run-time error when a worksheet is protected in MS-Excel?
- Conditional formatting using 3 conditions in Macro/VBA
- How to call function from another specific workbook in VBA?
- Open Google Chrome from VBA/Excel
- Excel VBA Run-time error 1004 when inserting or value formula into cell
- How to wait until ActiveWorkbook.RefreshAll finishes before executing more code