+ Reply to Thread
Results 1 to 5 of 5

Calculating short term and long term moving average in VBA

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    3

    Calculating short term and long term moving average in VBA

    Hi there

    Could you please help me with my code, I don't know where I went wrong or whether I have missed out anything. I have attached the data as well as my module that I have done so far.



    Thank you
    Attached Files Attached Files
    Last edited by ixthus; 09-20-2013 at 05:43 AM.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Calculating short term and long term moving average in VBA

    maybe "Cells" instead of "Cell"

  3. #3
    Registered User
    Join Date
    09-20-2013
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Calculating short term and long term moving average in VBA

    I just have one more problem.

    My module doesn't run as the name "Sub MovingAverage" can't be defined as noted on the compile error that pops up.

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Calculating short term and long term moving average in VBA

    Pl see the attached edited macro.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-20-2013
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Calculating short term and long term moving average in VBA

    I'm having difficulties with the VBA programming, just wondering if someone could give a basic example of how to set up a mortgage loan calculator using VBA?
    Cheers.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dealing with a long-term measurement data
    By Excelmania013 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 08-06-2013, 04:54 AM
  2. Long term lurker!!
    By Craig.Selby in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-10-2012, 09:37 PM
  3. [SOLVED] Long term: Add Symbolic Computation and new math Plot Functions
    By Robert Bigdowski in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2006, 04:25 AM
  4. calculating term of financial transaction
    By bookman3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. calculating term of financial transaction
    By bookman3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1