Skip to main content

Posts

Showing posts from August, 2020

Form (UI) for your excel sheet

  What is VBA, Why Should You Care? Visual Basic  for Applications (VBA) is the programming language behind Microsoft Office Products. It enables a programmer to automate these products. For example, you could write VBA code that enables the user to simply click a button.  The code could then take the graphs, tables, etc. that were automatically created in Excel and produce a slide deck. This slide deck could then be emailed to a set group of users within Outlook. All this can be completely automated. The applications of VBA are mind-blowing, in fact, I have had automated my job using VBA.  What Do You Need You only need Microsoft Excel. A great feature about VBA is that you do not need any other standalone editor, the editor is included within Excel. You can start  creating user forms to get yourself familiar with VBA. I chose a UserForm as an introduction to VBA because it showcases how you can turn an otherwise boring Excel spreadsheet into a Graphical User Interface (GUI) with butt