shankar
09-02-2010, 07:43 AM
Hi,
I have a weird problem. I want to be able to enter just the minus sign in any cell in my VBA application. It gets entered properly if I hit the return key after typing it. But if I use the arrow keys to move to adjacent cells, it enters the range of the new cell after the - sign, like I am trying to enter a formula, and doesn't change the cell value.
I tried setting Application.EnableAutoComplete = False and Application.DisplayFormulaAutoComplete = False, but am not able to change the behavior. I also formatted the cells to be only text. Any suggestions are welcome. Thanks.
Shankar
I have a weird problem. I want to be able to enter just the minus sign in any cell in my VBA application. It gets entered properly if I hit the return key after typing it. But if I use the arrow keys to move to adjacent cells, it enters the range of the new cell after the - sign, like I am trying to enter a formula, and doesn't change the cell value.
I tried setting Application.EnableAutoComplete = False and Application.DisplayFormulaAutoComplete = False, but am not able to change the behavior. I also formatted the cells to be only text. Any suggestions are welcome. Thanks.
Shankar