Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I'd like to try turning off the auto formula assumption in Excel.

I want to allow a user to enter either a Plus, Minus or Equals sign in a

cell and finish by

using an arrow key (to move to the next desired data entry cell). Nothing

else. It would

be nice not to require the text forcing single quote ['=] or a formula such as

[="="] .

You can do this if you use the [Enter] key, but then the cell selection

moves to where the

preference is set. However, when you use an arrow key, it is interpreted as a

formula and

the cell moved-to is inserted after the sign [Excel assumes you want a formula

referencing

that cell]. I could make the move-after-entry direction preference the most

likely, but

that can vary. I could also set the [enter]to not move the selection, forcing a

two key

finish-move operation.

Formatting the cell as Text converts a number to a string, but doesn't

convert these

signs into a string.

I could have the user enter text (a P, M or E), but the actual sign would be

nicer.

If there is an event which Fires when the arrow key is pressed, after a sign in

entered,

perhaps I could have a Macro add the leading single quote...but everyting I

found doesn't

fire when the arrow is typed, only after the [Enter]

Ideas?

Didn't find what you were looking for?
Find more on Disabling Formulas, Not calculation
Or get search suggestion and latest updates.

Related Topics:

- formula help but not vba please
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- Loop in formula
- Copy down formula with vba
- Array Formula
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- VBA code to add values in two cells which have formulas
- combining formula
- How to add several conditions for formula "SUMIF"
- R1C1 Formula
- Paste Formula help
- VBA or array formula?
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- Blank Formula bar
- Manually creating a row outline with no formula anywhere
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula
- Quotations in Formulas and strings