Brilliant Excel VBA Programming. (2013)

• Record Type: Book
• Other Names: Frye, Curtis
• Contents: Cover -- Brilliant Guides -- What you need to know and how to do it -- Author's acknowledgements -- About the author -- Contents -- Introduction -- 1 Recording and running macros -- Record a macro -- Run a macro -- Edit a macro -- Delete a macro -- Record a macro using relative references -- Record a macro using relative references -- Assign a macro to a keyboard shortcut -- Run a macro by clicking a shape -- Add a macro to the Quick Access Toolbar -- Customise a Quick Access Toolbar button -- Save a macro-enabled workbook -- Manage Excel 2010 security settings Change Protected View settings -- Change message bar settings -- Change data connection security settings -- Add a digital signature to a workbook -- 2 Starting with the Visual Basic Editor -- Introduce object-orientated programming -- Display the Developer ribbon tab -- Display the Visual Basic Editor -- Set project properties -- Create a code module -- Create a subroutine -- Create a function -- Add a comment to your code -- Run a VBA routine -- Rename a code module -- Delete a code module -- Export a code module to a text file -- 3 Working with data and variables Understand data types in Excel VBA -- Declare a variable -- Require variable declaration before use -- Manage variable scope -- Perform calculations using mathematical operators -- Define constant -- Define a static variable -- Define an array -- Define a multidimensional array -- Redefine an array -- Define a dynamic array -- Display an object type -- Define an object variable -- 4 Managing workbooks and files -- Open a workbook -- Open a text file as a workbook -- Open a file the user selects -- Save a workbook -- Save a workbook in a different format -- Detect if a workbook is open Close a workbook -- Create a new workbook -- Delete a file -- 5 Managing worksheets -- Add a worksheet -- Delete a worksheet -- Move a worksheet -- Copy a worksheet -- Hide or unhide a worksheet -- Rename a worksheet -- Protect a worksheet -- Print a worksheet -- 6 Managing ranges -- Activate a cell range -- Select a cell range -- Select the active region -- Refer to cells using Offset -- Insert a cell range -- Delete a cell range -- Hide a worksheet columns or rows -- Create a named range -- Resize a selected range -- Set the column width -- Set the row height -- 7 Managing cells Cut and paste a cell range -- Copy and paste a cell ranges -- Copy and paste a cell ranges using PasteSpecial -- Transpose a column into a row -- Create a cell comment -- Display a cell's comment -- Hide a cell's comment -- Delete one or all cell comments -- Fill a range of cells automatically -- Copy a range to multiple sheets -- Add a cell border -- Find a cell value -- Replace a cell value -- 8 Formatting worksheets and worksheet elements -- Apply bold, italic and underline formatting -- Change a cell's font -- Change a cell's font size -- Change a cell's font colour
• Publisher Details: Place of publication not identified : Pearson
• Publication Date: 2013
• Extent: 1 online resource
• Subjects: 005.54; Electronic spreadsheets; Business -- Computer programs; Tableurs; Business -- Computer programs; Electronic spreadsheets; Electronic books
• Languages: English
• ISBNs: 9781299283398; 9780273772903; 0273772902
• Related ISBNs: 129928339X
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.