It's FREE!

Create a Profile and Start Networking with HR Professionals
Register Now - It's Free Registration info
Member Content
Blogs | Questions | Files | Events | HR Groups | Members
PHR/SPHR Exam Prep Course
HRCI Recertification

  • Upcoming Events
  • Past Events
  • Public Events

More Webcasts

Live Webcast
Now in progress, started at 2:00 PM

Winning the Talent War

More Virtual Conferences

Live Conference
29 July - 30 July 2014 - In Progress

Rewards and Recognition

Upcoming Conference
13 August - 14 August 2014

Social Media and Employee Communications

My Events
View and edit your current events.
Add Event

Click the "add event" button to create a listing for your event

Advertise Here
Event Calendar / Automate your Spreadsheets – Part 2
Details & Time Frame
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.

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.
02/20/2013 11:00 am o'clock
02/20/2013 12:00 pm o'clock
Presentation Creator

Webcast information

Who should participate:

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

What you will learn:

  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

Recommended Resources:

There are numerous books on Excel and VBA. Look for the one that suits your learning style
View full details
Speakers You must be logged in to view speakers
Approved by This event has been approved by


Type last name, first name or company.

Type last name, first name, company or email address

Enter a personal message that will be sent to the recipients above

Link Use the following code to link to this event in your emails or website: