yongxuefeng的专栏

Excel VBA Course Notes: 2. Using Loops(File: VBA02-Loops.xls)Why Loops?The purpose of a loop is to get Excel to repeat a piece of code a certain number of times. How many times the code gets repea

Excel VBA Course Notes: 4. User Forms(File: VBA04-UserForms.xls)The Course Booking FormThe Course Booking Form is a simple form illustrating the principles of UserForm design and the associated VB

Excel VBA Course Notes: 1. Macro BasicsUsing the Macro RecorderOpen Excel and the VBE (Visual Basic Editor). Unless it has been changed, the VBE window contains the Project Explorer window and the