Excel Programming - Your visual blueprint for creating interactive spreadsheets

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