| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preparing Workbook for user input
I have a workbook that has 7 worksheets. I would like the user to see
all input cells as blank, and the calculated cells to be populated as the user goes along in the input process. How can I do this and avoid #REF from being displayed in calculated cells? Any tips are greatly appreciated. Julia |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Preparing Workbook for user input
Check for blank values in the input cells to avoid displaying invalid
or wrong calculations: =if(B5<"", YourFormula, "") does this help ? Fadi www.chalouhis.com/XLBLOG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prompt user for input and utilize that input | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
| Get User Input | Excel Programming | |||
| Get User Input | Excel Programming | |||
Linear Mode
