none
Is it faster to calculate in VBA or by writing Excel function in Excel worksheet? RRS feed

  • Question

  • I wonder which one is faster and why it is faster...

    VBA Userform's data will be calculated on the userform itself and the results will be displayed on Excel sheet.

    in such a program,(use Excel and VBA Both.)

    Which way is the right path to use the math function?

    should I prefer specific side?

    on complicated program with more than 1000 lines of VBA code.....

    there are many caculation....

    Tuesday, July 17, 2018 1:14 PM

All replies

  • In general, any time you can use a worksheet function, it is much much much faster than a VBA function.
    Tuesday, July 17, 2018 5:31 PM
  • In general, any time you can use a worksheet function, it is much much much faster than a VBA function.
    In cells for sure! However for other purposes (calculating Userform data?) simply calling app.WorksheetFunction can take longer than using an optimized VBA function.  Only way to compare of course is to test!
    Tuesday, July 17, 2018 9:44 PM
    Moderator