Want to boost enrolments?
Login and promote your courses
Searching for courses?
Login or register
Classes Course
Place:
London
Price:
Duration:
2 Days
Start:
20/01/2009 other dates
See course programme
Requirements:
Designed for experienced Excel users who have already begun to create macros and know ... see more
| Requirements |
Designed for experienced Excel
users who have already begun to create macros and know their way around
Excel's Visual Basic Editor.
|
| Price |
£550 + VAT
|
| Excel object model | |
| About classes and objects Objects and collections The hierarchy of objects Properties, methods and events The Locals Window The Immediate Window | |
| Function procedures | |
| Sub
versus function User-defined functions Declaring a function Calling a function Private and public scope Defining arguments Optional arguments | |
| The Application object | |
| When to use ScreenUpdating property DisplayAlerts property Setting CutCopyMode to false | |
| Dialogue boxes | |
| MsgBox
function InputBox function Application.Dialogs | |
| UserForms | |
| Creating a userform Displaying a userform Adding Label controls Adding a TextBox control The CheckBox control ComboBox and ListBox Adding CommandButtons Setting control properties | |
| Where | London, United House, North Road, Islington see map |
| When | Start: 20/01/2009 Finish: 21/01/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 14/04/2009 Finish: 15/04/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 23/06/2009 Finish: 24/06/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 01/09/2009 Finish: 02/09/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 24/11/2009 Finish: 25/11/2009 See calendar |
