Can someone please tell me what the VBA would be for the following question:

You need to plot the series of x,y points that solve the equation
exp(x+y)=(x^2)/y - y^2
For the range of x values shown below. Set up the Excel worksheet to solve this problem using Goal Seek for each row. Write a VBA macro program that uses a FOR/NEXT loop that can be associated with the command button to solve the entire problem. You can use the extra columns if desired.

NOTE: THe problem also has screen shot of excel looking like this:


[SOLVE FOR Y] <------Button
A B C D
4 x y
5 1
6 2
7 3
8 4
9 5
10 6


I appreciate the help!
Brandon