(Question re. Excel 2003)
I am just learning how to program and my question is hopefully a simple one for someone with more experience:
When a user selects a certain macro, I would like them for them to immediately be prompted to enter a number. This number (an "Instock Percentage") is constant throughout the document, so it only needs to be input once. How can I prompt for this value and then refer to it in later calculations? As an example, the "1000000" in the calculation below is where the user-defined value should go.
ActiveCell.FormulaR1C1 = "=IF(RC<1000000,RC[-1]/RC*1000000,RC[-1])"