Publisher's Synopsis
Excel® Programming 2nd Edition
Welcome to the only guidebook series that takes a visual approach to professional–level computer topics. Open the book and you′ll discover step–by–step screen shots that demonstrate over 120 key Excel programming techniques, including:
- Creating and launching keyboard shortcuts
- Setting macro security
- Assigning a digital signature
- Developing a function with VBA
- Displaying a built–in dialog box
- Converting a list into an array
- Using the msgbox function
- Processing a runtime error
- Saving a workbook in a specified format
- Finding the intersection of two ranges
