Forum Discussion
Need to modify a cell to accept keyboard input and then have a formula act on that input.
Greetings,
I have a totally functional grading spreadsheet that one person insists on a change.
What the requester would like is to have cell C4 receive a keyboard input, have a formula work on that value and then return the result to C4.
For example, the input value is 100%, the formula becomes C4=100*0.04 the result of the formula, 4% is placed back into C4. Can this be accomplished without resulting to Visual programing? Don
2 Replies
- Good spreadsheet design dictates that we do not mess with input values. It is a good idea to leave our data as is and do any processing of that data in other cells.
VBA code would be the only way to do that. It is impossible to do this within the Excel interface.
