Hi

I have a piece of code as part of a macro which subtracts 1 from a value
in cell D2

ActiveCell.FormulaR1C1 = "=RC[1]-1"

Sometimes , I need to vary this number. Rather than open the macro and
change the code each time , is it possible to program a popup to request
the value of the variable , and once executed proceed with the rest of
the macro?

Any help appreciated.



Best Wishes