Fülszöveg
Explore VBA programming and learn how to customize and automate many aspects of Excel
Maybe you're eager to learn Excel programming. Maybe it's your boss's idea. Either way, this book will have you on your way to Excel programming perfection in no time! It's a plain-English guide to what VBA is, how it works with Excel, essential programming concepts, and steps to creating some very cool dialog boxes, time-saving macros. Excel add-ins, and more.
• VBA-speak — learn the language of VBA and steps for creating a program in Excel
• Macro magic — automate common tasks, create custom buttons and commands, and develop new worksheet functions using VBA macros
• Programming basics — work with range objects, control program flow, automate procedures and events, and exterminate bugs in your code
• User communication — explore simple and custom dialog boxes and UserForm controls, tricks, and techniques
• All together now — apply your skills to design user-oriented applications, create...
Tovább
Fülszöveg
Explore VBA programming and learn how to customize and automate many aspects of Excel
Maybe you're eager to learn Excel programming. Maybe it's your boss's idea. Either way, this book will have you on your way to Excel programming perfection in no time! It's a plain-English guide to what VBA is, how it works with Excel, essential programming concepts, and steps to creating some very cool dialog boxes, time-saving macros. Excel add-ins, and more.
• VBA-speak — learn the language of VBA and steps for creating a program in Excel
• Macro magic — automate common tasks, create custom buttons and commands, and develop new worksheet functions using VBA macros
• Programming basics — work with range objects, control program flow, automate procedures and events, and exterminate bugs in your code
• User communication — explore simple and custom dialog boxes and UserForm controls, tricks, and techniques
• All together now — apply your skills to design user-oriented applications, create add-ins, and work with other Office applications
Visit the companion website at www.dummies.com/go/ excelvbaprogrammingfd3e for bonus chapters, source code, and additional information on the subject.
Vissza