Tab Strips and Multi Page Controls
I mentioned earlier that you can use frames to group related controls visually and help the user make sense of the form. However, there are two situations in which a frame falls down on the job. The first situation is when you need the form to show multiple sets of the same or similar data. For example, suppose you have a form that shows values for sales and expense categories. You might want the form to be capable of showing separate data for various company divisions. One solution would be to...
Accessing an Applications Builtin Dialog Boxes
Many VBA methods are known as dialog box equivalents because they let you select the same options that are available in an application's built-in dialog boxes. Using dialog box equivalents works fine if your procedure knows which options to select, but there are times when you might want the user to specify some of the dialog box options. For example, if your procedure prints a document (using the Application object's Printout method), you might need to know how many copies the user wants or...
- A
- Basic Error Trapping Strategy
- About the Author
- Accessing Worksheet Functions
- Acknowledgments
- Activating the Ribbons Developer
- Adding a Form to Your Project
- Adding Shapes to a Slide
- Arithmetic Operators
- Assigning an Object to a Variable
- Attaching a File to a Message
- Avoiding Variable Errors
- B
- Building VBA Expressions
- C
- Caution - 2
- Changing the Forms Design Time Properties
- Checking Spelling
- Checking the Selection Type
- Cjue
- Closing a Document
- Closing a Workbook
- Closing All Open Documents
- Code That Loops
- Code That Makes Decisions
- Collapsing the Selection
- Command Buttons
- Common Control Attributes
- Common Control Properties
- Comparison Operators
- Configuring Macro Security Settings
- Controlling the Order of Precedence
- Controlling Your VBA Code
- Converting a String into an Object
- Copying Controls
- Creating a Button
- Creating a Check
- Creating a Drop Down List
- Creating a New Document
- Creating a New Group
- Creating a New Slide
- Creating a New
- Creating a New Worksheet
- Creating a Reply or Forward
- Creating a Split Button
- Creating a Toggle Button
- Creating a User Defined Function
- Creating and Running Recorded Macros
- Creating Custom Controls
- Creating Custom Tabs
- Creating User Defined Constants
- Customizing an Existing Group
- Customizing an Existing
- Customizing the Office Ribbon
- D
- Debugging Tips
- Debugging VBA Procedures
- Declaring Variables
- Deleting a Record
- Deleting Text
- Digitally Signing a VBA Project
- Displaying Sentence Word Counts
- Displaying the Form
- Displaying the Visual Basic Editor
- Dynamic Arrays
- E
- Editing a Record
- Example Canning Spam
- Example Creating Advanced Rules for Incoming Messages
- Example Removing Attachments from a Forwarded Message
- Example Supplementing a Reminder with an Email Message
- Example The Window Object
- Example The Application Object
- Extending the Selection
- F
- Finding a Record
- Formatting Text
- Frames
- From Here - 2 3 4 5
- G
- Getting at the Recordset Data
- Getting Input Using inputBox
- Getting Input Using Msg Box
- Getting Started
- Getting the Name Space Object
- Grouping Controls
- H
- Handling Form Events
- Handling Object Events
- Hiding the BuiltIn Ribbon
- Httpmsdnmicrosoftcomlibrarydefaultaspurllibraryenusvbaxlhtml xlmscDialog Arg ListsHVasp
- I
- In the list the items that have the green blocks with motion lines are the methodswhereas the items that have the rectangles with a pointing finger are the properties
- Incoming Handling the Item Add Event
- Indenting for Readability
- Info - 2
- Inserting Controls on a Form
- Inserting Data into a Range
- Inserting Slides from a File
- Inserting Text
- Introduction
- L
- Labels
- List Boxes
- Listing A First Attempt at Calculating the Pre Tax Cost
- Listing A Function and Procedure That Determine and Select the Named Range Containing the Active Cell
- Listing A Function Procedure That Uses Various Date Functions to Calculate a Persons
- Listing A Function Procedure That Uses Words Word Count Dialog Box to Get the Total Number of Words in the Active Document
- Listing A Function That Accepts a Color Name as a String and Returns the Corresponding RGB Value
- Listing A Function That Counts the Number of Real Words in an Object Ignoring Punctuation Marks and Paragraph Marks
- Listing A Macro That Displays the Lengths of Sentences in the Active Document
- Listing A Macro That Selects Cell A on All the Sheets in the Active Workbook
- Listing A Procedure That Checks the Spelling of an Entered Word
- Listing A Procedure That Creates a Backup Copy of the Active Document on a Floppy Disk
- Listing A Procedure That Creates a Message Dialog
- Listing A Procedure That Inserts Hyperlinks for a Specified Style of Heading
- Listing A Procedure That Prompts the User for Input and Then Displays the Data
- Listing A Procedure That Prompts You to Specify the Number of Sheets You Want in a New Workbook
- Listing A Procedure That Sends an Email Message
- Listing A Procedure That Sets Up the Text and Animation Settings for the First Slide of the Juggling Presentation
- Listing A Procedure That Sets Up the Titles Pictures and Text Instructions for Each of the Juggling Slides
- Listing A Procedure That Stores the Names of the Worksheets in a Dynamic Array
- Listing A Procedure That Tests the Evaluate Function
- Listing A Procedure That Uses ifThen Else
- Listing A Procedure That Uses Multiple ifThen EiseStatements
- Listing A Procedure That Uses Resize to Adjust a Named Range
- Listing A Procedure That Uses Select Case to Convert a Raw Test Score into a Letter Grade
- Listing A Procedure That Uses Select Case to Test Multiple Values
- Listing A Procedure That Uses Selection Extension to Format Different Aspects of a Paragraph
- Listing A Procedure That Uses the Offset Method to Concatenate Two Text Strings
- Listing A Procedure That Uses the Or Operator to Perform Multiple Logical Tests
- Listing A Procedure That Uses the Rows Method to Insert a Row Before the Last Row of a Range
- Listing A Procedure That Uses the Switch Function to Convert a Test Score into a Letter Grade
- Listing A Procedure to Send an Email Message When Outlook Processes a Reminder
- Listing A Procedure to Test the Pick Folder Method
- Listing An Event Handler for the Item Add Event That Implements Custom Rules
- Listing An Event Handler for the Item Add Event That Moves Junk Email
- Listing Continued - 2 3 4 5 6 7 8 9 10
- Listing Deleting a Record
- Listing Editing Recordset Data
- Listing Event Handlers for Outlooks Startup and Quit Events
- Listing Getting Recordset Data
- Listing Macros to Navigate from One Sentence to Another
- Listing Procedures That Use the onKey Method to Set and Reset a Key Combination
- Listing Retrieving an Entire Recordset
- Listing The Correct Way to Calculate the Pre Tax Cost
- Listing This Procedure Asks the User Whether He or She Wants to Run the Presentations Slide Show
- Listing This Procedure Creates a New Presentation and Then Saves It
- Listing This Procedure Ties Everything Together by Calling Each of the Code Listings Individually
- Listing Using a Bookmark to Navigate a Recordset
- Listing Using a Table to Open a Recordset Object
- Listing Using Properties to Open a Recordset Object
- Listing Version of the Big Numbers Procedure That Terminates with the Exit Do Statement If the Current Cell Isnt a Number
- Logging On to an Outlook Session
- Logical Operators
- Mail Item Object Methods
- Mail Item Object Properties
- Making Multiple Decisions
- Methods of the Worksheet Object
- Microsoft Office System
- Monitoring Procedure Values
- More Complexity Means More Power
- Moving Controls
- Moving the Insertion Point
- Multidimensional Arrays
- N
- Navigating Records
- Note the use of the underscore in Listing This is VBAs code continuation characterits use ful for breaking up long statements into multiple lines for easier reading One caveatthough Make sure you add a space before the underscore or VBA will generate an e
- Opening a Document
- Opening a Presentation
- Opening a Recordset the Full Open Method Syntax
- Opening a Recordset Using a select String
- Opening a Recordset Using a Table
- Option Buttons
- Outgoing Handling the Item Send Event
- P
- Pausing a Procedure
- Pausing a Running Macro
- Presentation Object Methods
- Presentation Object Properties
- Processing the Form Results
- Programming Access Databases
- Programming the Paragraph Object
- Programming Word
- Prompting the User for a Folder
- Properties of the Worksheet Object
- R - 2 3
- Reading and Changing Range Text
- Recalculating Workbooks
- Red An integer value between and that represents the red component of the color green An integer value between and that represents the green component of the color blue An integer value between and that represents the blue component of the color
- Referencing Default Folders
- Resizing a Range
- Retrieving an Entire Recordset
- Retrieving One or More Entire Rows
- Returning a Range Object
- Returning Data About a Range
- Running the Slide Show
- Saving a Document
- Saving Every Open Workbook
- Scrollbars
- Selecting a Cell or Range
- Selecting Controls
- Setting Control Properties
- Setting the Tab Order
- Setting the Value of a Property
- Setting Up a Reference to Outlook
- Shutting Down the Visual Basic Editor
- Sizing Controls
- Slide Object Properties
- Slide Show Settings
- Slide Show Transitions
- Some Event Like Methods
- Some MAPiFolder Methods
- Some Shape Object Methods
- Some Shape Object Properties
- Specifying a Document Object
- Specifying a Presentation Object
- Specifying a Shape
- Specifying a Slide
- Specifying a Window Object
- Specifying a Workbook Object
- Specifying a Worksheet Object
- Specifying the Message Recipients
- Specifying the Number of Sheets in a New Workbook
- Spin Buttons
- Step Copy the Custom XML Markup File to the Document Package
- Step Create a Macro Enabled Office Document or Template
- Step Create a Text File and Add the Custom XML Markup
- Step One Create a Reference
- Step Two Create a Data Source
- Stepping Through a Procedure
- Storing User Input in a Variable
- Symbols
- T
- Table VBAs Date and Time Functions
- Taking Advantage of Intelli Sense
- Text Boxes
- The Appearance Category
- The Behavior Category
- The Choose Function
- The Concatenation Operator
- The iif Function
- The Is Operator
- The Juggling Application
- The Misc Category
- The Not Operator
- The Object Hierarchy
- The Order of Precedence
- The Picture Category
- The Position Category
- The Range Method
- The Range Property
- The Recent Files Object
- The Scrolling Category
- The Switch Function
- Tips for Faster Procedures
- Touring the Visual Basic Editor
- Trappable VBA Errors
- Trapping Program Errors
- U
- Understanding Expressions
- Understanding Operator Precedence
- Understanding Program Variables
- Understanding VBA Procedures
- Unloading the Form
- Using Array Variables
- Using BuiltIn Constants
- Using DoLoop Structures
- Using Exit For or Exit Do to Exit a Loop
- Using For Next Loops
- Using IfThen to Make True False Decisions
- Using IfThen Else to Handle a False Result
- Using Multiple ifThen Else Statements
- Using the And and On Operators
- Using the Folders Property
- Using the Immediate Window
- Using the Select Case Statement
- Using the Selection Object
- Using the Words Object
- V
- Variable Data Types
- VBA Functions
- VBA Statements
- VBA Tips and Techniques
- VBAs Financial Functions
- VBAs Math Functions
- W
- We Want to Hear from
- What Does VBA Have to Do with Macros
- What Is a Macro
- What Is an Object
- What You Should Know Before Reading This Book
- Whats in the Book
- Working with Attachments
- Working with Controls
- Working with Database Records Opening a Recordset
- Working with Date Expressions
- Working with Logical Expressions
- Working with Modules
- Working with Multiple Properties or Methods
- Working with Object Collections
- Working with Object Methods
- Working with Object Properties
- Working with Objects
- Working with String Expressions
- Working with the Application Window
- Working with the Err Object
- Working with the Range Object
- Working with the Sentences Object
- Working with VBA Operators
- Writing Your Own Macros