Changing variables within the code with a button?

[johandenver]

Hello,

I'm really not very good at programming so I have a question that I hope someone with greater knowledge might be able to answer.
Is it possible to change the values of variables that are set in a subroutine with another subroutine?

I have a subroutine called twometerspf that contain the following values:
difference1 = "1.93"
difference2 = "1.94"
difference3 = "1.95"
difference4 = "1.96"
difference5 = "1.97"

What I want to do is to be able to change these values with a click of a button in the worksheet.

For example writing 1.63, 1.64, 1.65, 1.66 and 1.67 in specific cells and clicking the button would cause the variables to change to the below.
difference1 = "1.63"
difference2 = "1.64"
difference3 = "1.65"
difference4 = "1.66"
difference5 = "1.67"

If possible I'd also like to save these new values when saving the workbook, IE overwriting the original values in the subroutine. Is this possible?

Regards
/Johan

[davesexcel]

Make the variables = a cell

Please Login or Register  to view this content.

[johandenver]

Thanks, I'll try that :-)