| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you put a formula on a field that requires user input?
Here is the scenario that I need help on:
Cell_1 is a cell that doesn't contain any formulas or conditions. Checkbox_A is a checkbox from the form tool. If Checkbox_A is 'FALSE'(not checked), I want Cell_1 to change/default to the number 0. If Checkbox_A is 'TRUE', I want the user to still be able to enter a number into Cell_1, let's say 10,000. Normally, I would just put an 'if statement' on Cell_1 but since I also am expecting the user to input data in this cell, it will overwrite the formula. Am I overlooking something simple here? Is there VB code that would take care of this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How get user input that can then be used in formula, as criteria? | Excel Worksheet Functions | |||
| Can I request user in input variable value within formula? | Excel Worksheet Functions | |||
| How can I calculate user input from a combo box into a formula? | Excel Worksheet Functions | |||
| User input formula variable | Excel Programming | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Threaded Mode
