I need to do my final year project in Excel using VBA.
The project is in such a way that i can generate curves using Excel.
I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail.
Could anyne please advise me on this? I am a newbie to VBA, so i'm rather lost now.. Thanks in advance.
Dim MyAngle, MySecant
MyAngle = 1.3 ' Define angle in radians.
MySecant = 1 / Cos(MyAngle) ' Calculate secant.
First of all, thanks for the advice.
Do you mean that if i add the above source code into the VB editor then i'll be able to calculate secant in excel? how about cosine. i tried to use the formula =COS(pi*A2/180) but the results i obtained is #NAME?. I'm using excel 2003.
It works.. :)) By the way, is it possible to draw the cosine graph based on the formula using excel? It seems like, i can only plot the graph based on the values keyed in the tables. Furthemore the graph obtained using the excel's Chart>XY Scatter doesn't look like cos graph. Do i need to write a program in order to to draw the cosine graph?
