Using Visual Basic within excel for iteration of f(x) - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Using Visual Basic within excel for iteration of f(x)

elwarsielwarsi Posts: 2Member
Hi there hoping someone can give me some pointers, as sadly my teacher gave us very little to go on, never used developer VBA within excel before last week.
I have been instructed to enable developer on excel, click on VBA, click insert , 'module', which pops up a window, enter a function into the window... 'type in' ........
function g(x)[enter], 'then type in' g = 'some equation of x' [enter]
then goto excel make a header of
x(n) g(n) error
='some value of x' =g(x)
=B3 =g(A4) =ABS(A4-A3)

My problem is that I constantly get crashes, and loose data where the excel states NAME PROBLEM, Ive tried to get a beginers guide on web no job, just ordered some books to help...

for now can anone tell me is there a way to declare a formula and relate it to a cell within excel, thereby avoiding using 'rem or ' ' at the beginng of a line.. I found the following code...
Set myRange = Worksheets("Sheet1").Range("A1:C10")
and wondered is this the key to my quest.
please can someone tell me how could I do this if what I require is possible..

The main use I need for the formula, is to reuse the formula on a variety of iterations of f(x).
Id like to create 3 versions of x for each f(x), and have the 3 calculations on the same page..
many thanks
Elwarsi :-)

Sign In or Register to comment.