Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add a formula to one cell by entering text in another cell.
Example: Cell G1 contains Y or N. When the value is Y, A2 is made blank. If
value is N, A2 has an IF formula added. It is done as soon as the enter key is pressed or the arrow keys are used to move to another cell. It appears to be a hidden script, but I can't find it anywhere. If someone knows how this works, that may be able to help me locate it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add a formula to one cell by entering text in another cell.
See if it is event code. On that sheet, right-click the sheet tab, select
View Code from the menu, and check if there is anything in the pop-up code window. -- HTH RP (remove nothere from the email address if mailing direct) "Matt" wrote in message ... Example: Cell G1 contains Y or N. When the value is Y, A2 is made blank. If value is N, A2 has an IF formula added. It is done as soon as the enter key is pressed or the arrow keys are used to move to another cell. It appears to be a hidden script, but I can't find it anywhere. If someone knows how this works, that may be able to help me locate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering multiple lines of text in a cell | Excel Discussion (Misc queries) | |||
entering a formula into a cell with text | Excel Discussion (Misc queries) | |||
after entering a text in one cell, next cell should disp the entd | Excel Discussion (Misc queries) | |||
text in a cell upon entering the cell | Excel Discussion (Misc queries) | |||
What is the Chr() code for Alt+Enter in a cell when entering text? | Excel Discussion (Misc queries) |