VBA

Introduction to VBA Programming. In the previous chapter, we mentioned that VBA was Excel’s programming language. It turns out that VBA is the programming language for all the Microsoft Office applications. Also VBA is becoming the programming language of other popular applications. Some of the other applications that are using VBA as its programming language are Visio and Business Objects. This is very exciting news for people who automate applications. The main advantage is that a person does not have to constantly learn a new language when he or she deals with a new application. Another important advantage of an application adopting VBA as a programming language is it is a language that uses most of the programming concepts that professional programmers use; therefore, VBA is a powerful language. Now, it is easier for an Excel programmer to do Access VBA programming, Word VBA, or even PowerPoint VBA programming. The finance people would say that there is a return in the investment of time in learning VBA.


References in zbMATH (referenced in 53 articles , 1 standard article )

Showing results 1 to 20 of 53.
Sorted by year (citations)

1 2 3 next

  1. Wild, T.B., Loucks, D.P., Annandale, G.W.: SedSim: A River Basin Simulation Screening Model for Reservoir Management of Sediment, Water, and Hydropower (2019) not zbMATH
  2. Duarte, Abraham; Laguna, Manuel; Martí, Rafael: Metaheuristics for business analytics. A decision modeling approach (2018)
  3. Klosterhalfen, Steffen T.; Holzhauer, Falk; Fleischmann, Moritz: Control of a continuous production inventory system with production quantity restrictions (2018)
  4. K. Thomas Klasson: QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures (2018) not zbMATH
  5. Delgoshaei, Aidin; Rabczuk, Timon; Ali, Ahad; Ariffin, Mohd Khairol Anuar: An applicable method for modifying over-allocated multi-mode resource constraint schedules in the presence of preemptive resources (2017)
  6. Gan, Guojun; Valdez, Emiliano A.: Valuation of large variable annuity portfolios: Monte Carlo simulation and synthetic datasets (2017)
  7. Röman, Jan R. M.: Analytical finance. Volume I. The mathematics of equity derivatives, markets, risk and valuation (2017)
  8. Viswanathan, Rama; Liang, Sijia; Yang, Yang; Jungck, John R.: BioGrapher: visualization of graph theoretical patterns, measurements, and analysis in mathematical biology (2016)
  9. Chan, Ngai Hang; Wong, Hoi Ying: Simulation techniques in financial risk management (2015)
  10. Tay, Kim Gaik; Cheong, Tau Han; Lee, Ming Foong; Kek, Sie Long; Abdul-Kahar, Rosmila: A fourth-order Runge-Kutta (RK4) spreadsheet calculator for solving a system of two first-order ordinary differential equations using Visual Basic (VBA) programming (2014) MathEduc
  11. Barr, Graham D.; Scott, Leanne D.: Teaching statistical principles with a roulette simulation (2013) MathEduc
  12. Nahrstedt, Harald: Algorithms for engineers. Technical realisation with Excel and VBA (2012)
  13. Oliveira, Margarida; Nápoles, Suzana; Oliveira, Sérgio: Fourier analysis: graphical animation and analysis of experimental data with Excel (2012) MathEduc
  14. Barr, Graham D.; Scott, Leanne: Teaching statistics in a spreadsheet environment using simulation (2011) MathEduc
  15. Hadjidoukas, P.; Bousis, C.; Emfietzoglou, D.: Parallelization of a Monte Carlo particle transport simulation code (2010)
  16. Shivaswamy, Shashishekar: Finite element analysis and programming. An introduction. (2010)
  17. Hiestand, James W.: Numerical methods with \textttVBAprogramming. (2009)
  18. Benacka, Jan: Three spreadsheet models of a simple pendulum (2008) MathEduc
  19. Bendoly, Elliot: Excel basics to blackbelt. An accelerated guide to decision support designs (2008)
  20. Fusai, Gianluca; Roncoroni, Andrea: Implementing models in quantitative finance: methods and cases (2008)

1 2 3 next