Why do you need an input box at all? It sounds like you should be using a table (so all references will be dynamic) or at worst you could just enter the value in a cell and refer to that from the relevant formulas, or via a named range.