| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a latching function
If cell (A) = a predetermined value then cell (B) = x. A simple if
statement,but, I want cell (B) to act as a latch. Once cell (A) has switched cell (B) to X I want cell (B) to stay in that condition even if the value of cell (A) changes from the predetermined value. i.e. I want cell (B) to behave like a latch, once it has been switched on it stays on regardless. Can you help. Kind regards -- KenH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Threaded Mode
