+ Reply to Thread
Results 1 to 3 of 3

Automate Calculation with help of VBA

  1. #1
    Registered User
    Join Date
    01-25-2011
    Location
    Amsterdam
    MS-Off Ver
    Excel 2003
    Posts
    19

    Automate Calculation with help of VBA

    Hello Everyone!
    I am building a xls based tool where there s a 'input' sheet that require data entry. The subsequent sheets (5 in no.) are 'calculation / result' sheets based on values from the 'input' sheet.
    Now to initiate all calculations I have used the code - Application.CalculateFull.
    This code is perfect as it forces a full calculation in all the sheets also including the 'input' sheet with press of a Tab/button (which I have created).
    What I ideally want is that in the 'input' sheet the calculation to be automated, while in the remaining it remains the same (ie forced calculation with a click on the Tab). I tried using Activesheet.calculate in 'input' sheet but it does not help.
    Can anyone tell me how to resolve this?

  2. #2
    Registered User
    Join Date
    01-25-2011
    Location
    Amsterdam
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Automate Calculation with help of VBA

    Hello!
    The question is still open...
    any help is appreciated.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Automate Calculation with help of VBA

    I can't see why you need VBA, set Calculation to Automatic
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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