Chapter 14: UserForm Examples


image from book  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.

CROSS-REFERENCE  

Chapter 15 contains additional examples of more advanced UserForm techniques.




Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net