Vba code for newton raphson

[albeezy]

Can somebody tell me how to write a VBA code for Newton Raphson
The code should begin like this
Function Newt_Raph_1 (x_initial,cc,n)




I have the code for matlab but i cant seem to write it in VBA
%STEP 1: Name the function and its arguments.
function NewtRaph(x_init, cc, n)
%STEP 2: GIVE INITIAL VALUES, and other starting information.
x=x_init;
%STEP 3: RUN THE LOOP.
for i=1:n;
x_prev=x;
x=x-func2(x)/der_func2(x);
if 100*abs((x-x_prev)/x_prev)<cc,break,end;
end
%STEP 4: REPORT RESULTS.
disp(x)
%STEP 5: END THE FUNCTION.
end


If someone could please help id appreciate it HW#6_Instructions_Fall_2014.pdf
Attached is the problem. Number 1 part g is the problem i need help doing thanks

[shg]

To suggest the obvious, have you tried googling excel vba newton raphson

[albeezy]

Yes i have not been able to find what i need so i tried this to see if anyone knew anything about it

[MrShorty]

It appears that you already know the basic idea behind the NR algorithm (unless you have simply copied the Matlab code from someone else), so it should be as simple as translating each statement/block into its VBA equivalent. Are there specific statements you need help with, or are you just completely unfamiliar with VBA.

Assuming the latter, I would suggest the following help files:
How to use the Function() statement to define a function procedure: http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx
For...Next loops: http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx

From there, what specifically are you having trouble with?