Microsoft Excel Series - Part 4: Creating Custom Excel Interfaces with User Forms

Duration: 120 Minutes
Part 4 of this Microsoft Excel macros training series presented by Excel expert David Ringstrom, CPA, will explore how to create a UserForm in Excel. It will help attendees identify how to create macro buttons that enable users to display UserForms on demand. The webinar also will define the benefits of using Visual Basic for Applications (VBA) macros and illustrate how to apply the Tag property within UserForm controls.
Creating UserForm in Excel
Instructor: David H. Ringstrom
Product ID: 502006
Objectives of the Presentation
  • State how to create a UserForm in Microsoft Excel
  • Identify how to create macro buttons that enable you to display UserForms on demand
  • Recall how to create custom forms that allow you to better control a user's actions
  • Apply techniques that empower you to create an input form, test and immediately respond to invalid inputs, and then save the resulting data to a worksheet
  • Define the benefits of using Visual Basic for Applications (VBA) macros
  • Apply the Tag property within UserForm controls
Why Should you Attend
This last webinar in the four-part macros series will discuss UserForms, an aspect of Visual Basic for Applications (VBA) macros. Attendees will learn how to create a UserForm that enables them to pick and choose worksheets to be printed from any workbook. In addition, participants will discover techniques that empower them to create an input form, test and immediately respond to invalid inputs and then save the resulting data to a worksheet.

Excel expert David Ringstrom, CPE, will demonstrate techniques from Excel 2016, but his detailed handouts identify differences in Excel 2007, 2010, 2013 and 2016 when needed. His webcasts are fast-paced and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. David's detailed handouts with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast.

Areas Covered
  • Creating UserForms in Microsoft Excel
  • Creating a UserForm that enables you to pick and choose which sheets within a workbook you want to print
  • Understanding a nuance of UserForms related to Print Preview that can cause Excel to freeze
  • Utilizing the Tag property within UserForms to streamline the process of moving data between spreadsheet cells and fields
  • Creating macro buttons that enable you to display UserForms on demand
  • Exploring events that can be triggered based on actions within UserForms
Who will Benefit
  • Banking
  • Finance
  • Insurance
  • Education
  • Telecom
  • IT
  • CPAs
  • CFOs
  • Controllers
  • Marketing
  • Sales
  • Investments
  • Pharmaceutical
  • Medical Devices
  • FDA
  • Aviation
  • Energy
  • Retail
  • Human Resource
  • Logistics and Supply Chain
  • Accountants
  • Audit
This webinar is a part of " Microsoft Excel Macros-4-Part Series: Your Key to Success In The Modern Business World" Webinar Series.Click here to know more.


$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
View More