Das VBA-Kochbuch für Excel-Anwender

The practical guide on how to make your tasks in Excel even more efficient:

• Practical VBA recipes for everyday use.

• Quick and efficient solutions for reference.

• With numerous examples and tips - also available for download.

You work with Excel, occasionally use macros and VBA (Visual Basic for Applications) &ndash, and sometimes lack ideas on how to approach it? Then this collection of recipes will serve you well as a reference work when it comes to implementing recurring tasks quickly and easily with VBA. The authors do not bother with complicated explanations, but present basic recipes for everyday use as well as many appetising examples. They will round off their explanations with practical tips on how to cook and how to use individual ingredients. In addition, they serve you specialities such as your own forms, the control of diagram elements or the data transfer to Word and PowerPoint. So put together your own VBA menu and look forward to easy-to-follow instructions! All recipes are also available for download.

From the contents:

• Set up and optimise your working environment

• The basic ingredients: Variables, constants, queries, loops, etc.

• Basic recipes for cells, ranges, worksheets and workbooks&nbsp,

• Communication: integrated and own dialogue windows (forms)

• Saving, renaming or deleting workbooks via VBA, managing folders

• Interactive diagram design and colour palettes

• Sort, filter and merge tables

• Error handling and performance

• Convert, split and adjust values

• Table functions and own functions

• Data exchange with Word, PowerPoint and Outlook.