| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnChar function
In Excel, is there a set of events per cell. Can I trigger on data entry into a cell?
eg. As a user types chars, I want to help the user with unique expansion as in the following. User types 3HN10 Expands to "3 Hearts by North Making 10" I found the OnChange event to use after the event, but I cannot find anything to allow processing on entry of a cell. Regards and thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
OnChar function
You'd have to modify the entry after it's completed. It's not possible to
run a macro while an entry is being made. You might see if adding your items to the Tools, AutoCorrect list is helpful. -- Jim Rech Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Linear Mode
