English 中文
VBA 
搜索課程簡介

 
 
Excel Automation Using Macros and VBA 


Recording macros and Buttons
  • Absolute and relative recording 
  • Where macros can be stored 
  • Assigning macros to Buttons
Visual Basic Programming Basics
     
  • Getting help in VBA 
  • Create a subroutine 
  • Create a function 
  • Declare a variable 
  • Create a constant 
  • Comment your code
 
 

另備有不同程度之 Excel 課程以供選擇。
詳情請按此

 
 
Working with cells
  • Selecting cells (absolute)
  • Selecting cells (relative) 
  • Selecting to the end of a block 
  • Selecting a range by its corners 
  • The VB code editor 
  • Using Project Explorer 
  • Creating modules 
  • Basic subroutines and comments
Working with ranges
  • Using the range property 
  • Using the cells property 
  • Combine multiple ranges 
  • Using the offset property 
  • Delete a range of cells 
  • Hide a range of cells 
  • Specify the name of a range 
  • Resize a range 
  • Insert a range 
  • Set the width of columns in a range
Messages and variables
  • Input boxes and message boxes 
  • Assign Values to Variables 
  • Declaring variables, array, Multidimensional Array 
  • Redimension an Array 
  • Create a user-defined data type
Working with Excel Object Model
  • An introduction to the Excel object model 
  • Using object browser 
  • Create an object variable 
  • Objects and collections 
  • Methods and properties 
  • Display a BUilt-in dialog box
Loops and conditions
  • Simple IF conditions 
  • Multiple IF and SELECT … CASE 
  • Execute tasks a specific number of times 
  • Using the For Each Next Loop 
  • Jump to a specific location in a Macro
Looping over collections
  • Object variables 
  • Looping over collections
DeBUgging and error handling
  • Setting breakpoints 
  • Stepping through macros 
  • ON ERROR statements
Event handling
  • Assigning macros to events 
  • Cancelling events
Functions
  • Declaring functions 
  • Passing arguments
Using Built-in functions and statements
  • Using Excel worksheet functions 
  • Using the MsgBox function 
  • Using the InputBox function 
  • Retrieve current date and time 
  • Determine the amount of time between dates 
  • Format a date expression 
  • Format a numerical expression 
  • Remove extra spacing from a string 
  • Passing arguments 
  • Compare two string
Working with other workbooks and files
  • Open a workbook 
  • Open a text file as a workbook 
  • Open a file requested by the user 
  • Save a workbook 
  • Save workbook in format specified by user 
  • Determine if a workbook is open 
  • Close a workbook 
  • Create a new workbook 
  • Delete a file 
  • Find a file
     
  頂點  
     
持續進修基金課程
Diploma Course in Computer Graphic Design
Diploma course in 3d Modelling and Animation
Diploma in Multimedia Web Design and Development
 
 
  Relating Courses  
 
  Excel I
  Excel II
  Excel-Advanced
  Financial Accounting with Excel
 
 
 
  Schedules
 
 
VBA0031 15 Mar view schedule enrol
 
VBA0041 20 Apr view schedule enrol