New to macros, and can't seem to figure this out. What I want to do is create a box where users can enter a range for a chart: the maximum value, the minimum value, and the size of each increment. After entering this information, I'd like the macro to create a table and automatically fill them with data then create a table output.

For example, say the max point is 0.80, min is 0.70, and increment is 0.01. The macro would automatically build a table, enter every 0.01 increment between (inclusive) 0.7 and 0.8, and using a prewritten formula plot output values (say profit/loss) for each of those increments. Then, it would draw a line chart showing the profit/loss vs the increments of the selected range.

As I said I'm very new to macros, this all seems quite daunting so any help is much appreciated. Thanks!