Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

 Download CD Content

Overview

In This Chapter

This chapter presents many useful and informative examples that introduce you to some additional techniques that involve UserForms.

• Using a UserForm for a simple menu

• Selecting ranges from a UserForm

• Using a UserForm as a splash screen

• Changing the size of a UserForm while it's displayed

• Zooming and scrolling a sheet from a UserForm

• Understanding various techniques that involve a ListBox control

• Using an external control

• Using the MultiPage control

• Animating a Label control

You might be able to adapt these techniques to your own work. All the examples are available on the CD-ROM that accompanies this book.