| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If...then formula, otherwise "entry field"
I am looking for some VBA code that can be used to control whether a cell is
a formula or an entry field. In my sheet, the user selects a name from a drop down list and a vlookup then populates the salary cell. However, the user can also choose "TBD" or "Seasonal" in which case I need the salary cell to become an entry field where the user would then input the salary amount for these special cases. Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "What-if" formula for either a manual entry and automated entry | Excel Discussion (Misc queries) | |||
| Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
| Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" | Excel Discussion (Misc queries) | |||
| If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
| "Clean Me" Macro is giving "#VALUE!" error in the Notes field. | Excel Programming | |||
Threaded Mode
