This course will expose the user with the construction of custom Visual Basic functions which can be used either in programming code or spreadsheet formulas. This course will also demonstrate how to create custom dialog forms for gathering data input and returning values into the spreadsheet.
Objective: Upon completion of this course the user will be able to create functions for computing values that can be used in programming procedures or in spreadsheet operations. In addition, the user will create custom forms featuring a variety of ActiveX controls designed to return input values into spreadsheet cells.
- Creating Custom Functions
- Function procedures
- Function arguments
- Using the Immediate Window for testing
- Working with Array Variables
- Writing a Select Case statement
- Using functions in code structures
- Using functions in spreadsheet formulas
- Function procedures
- Creating Custom Dialog Forms
- Exploring ActiveX controls
- Text boxes
- Combo boxes
- Option groups
- Spin buttons
- Command buttons
- Exploring ActiveX controls
IMPORTANT INFORMATION ABOUT PARTICIPATION: As part of our sponsorship with NASBA, we have agreed to provide at least three (3) instances of engagement per CPE hour (50 minutes). These may come in the form of open-ended questions, hand-raising, polling, and other techniques. You MUST answer or respond to all three opportunities to engage in order to receive credit for that CPE hour. Knowledge Source Inc. retains these responses after all CPE classes for audit purposes.
Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.