Excel treating text as function
I am writing an Excel app in which the user needs to enter dashes
frequently ('-'). However, Excel thinks the user is trying to enter a
function, and if the user presses the down arrow, Excel inserts a
reference to that cell instead of moving down to that cell. Is there
any way to tell Excel not to expect a function? Setting the cell's
format to text doesn't work, and the Worksheet_Change event doesn't
fire until the user is finished editing the cell. Maybe there is some
property in the Application object I can set to fix this?
TIA,
- Bill
|