Automate your Spreadsheets – Part 2

Technology promises to deliver solutions, but often falls short because core HR technology solutions are built to address the very important compliance and administration tasks of their profession, largely driven by Payroll, Benefits, and record keeping.

In Part I, we showed how Excel and VBA can be part of an HRIS strategy that uses the core HRIS for what it does well, and Excel and VBA to give you all the ‘good stuff’ you need to be an effective business partner. It would be helpful to review this presentation prior to viewing Part 2.
http://www.hr.com/en/webcasts_events/webcasts/archived_webcasts_and_podcasts/automate-your-spreadsheets-%E2%80%93-using-excel-and-vba-p_h7v5td2z.html

VBA allows you to automate the spreadsheets, and develop powerful and sophisticated business tools in Excel. If you regularly use spreadsheets to produce a series of monthly charts and reports, or send spreadsheets to managers, you can have VBA do the same task for you in a matter of seconds.

Part 1 provided an overview of:
• Why the Macro recorder simply doesn’t work
• The basic principles of the VBA language
• The concept of a VBA project.
• The concept of a VBA procedure.
• How to manage and use VBA modules that store VBA code
• The basic operation of the VBA Editor

We use the specific example of Salary Planning Tools to show how you can use VBA code to automate many time-intensive processes in developing tools, such as importing data . Part 2 will focus on using GUIs to develop a flawless and foolproof workflow. We will show you how ‘Userforms’ in VBA can display information and allow you input data.

We will show:
• The input box and the message box
• Creating a Userform
• Calling and Hiding a Userform
• Adding controls to an existing form
• Using Basic form controls
• Adding Option buttons to a userform

We will show some specific examples of what can be done to simplify any process, and the specific VBA code that is used to automate many time intensive processes.

Any HR professional. Not necessarily to lear VBA, but to understand the power of this sophisticated tool

1. VBA with Excel can automate spreadsheets, and create powerful and sophisticated business solutions. All with the software you already have on your desktop
2. Userforms and GUIs can create a flawless and foolproof workflow
3. How to build a userform

There are numerous books on Excel and VBA. Look for the one that suits your learning style

		Roy Farrell HR Value, LLC View Profile

		Kenn Williamson HR Value LLC View Profile