Excel: Howto about excel – KB Jewels


How to Activate a Perpetual License in Office XP Program


How to Add a Digital Signature to a Custom Macro Project in an Office XP Program


How to Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000


How to Add Text to the X or Y Axis on a Chart


How to Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000


How to Add the Workbook Path to the Header and Footer in Exce


How to Add Totals to a Stacked Column Chart in Excel 2000


How to Analyze a Questionnaire or Survey with a PivotTable in Excel 2000


How to AutoFilter Records Based on Cell Formatting in Excel 2000


How to Automate Embedded Office ActiveX Documents with C++ .NET


How to Automate Excel From C++ .NET and MFC To Fill or Obtain Data In a Range Using Arrays


How to Automate Excel Text to Speech in Another Office Progra


How to Binding for Office Automation Servers with Visual C# .NET


How to Build an Office COM Add-in by Using Visual Basic .NET


How to Build an Office COM Add-in by Using Visual C# .NET


How to Bypass the Text Import Wizard When You Import Files in Excel 2000


How to Calculate Ages Before 1/1/1900 in Excel 2000


How to Calculate Compound Interest for an Intra-Year Period in Excel 2000


How to Calculate the nth Root of a Number in Excel 2000


How to Calculate the Number of Months Between Two Dates in Excel 2000


How to Call a Visual Basic .NET Class Library from Visual Basic for Applications in Microsoft Office


How to Change Default Colors in Excel 2000


How to Change Default Font and Font Size in Excel 200


How to Change Default Font and Font Size in Excel 2000


How to Change the Chart Type of a Series in a Combination Chart in Excel 2000


How to Change the Color Palette for Workbooks in Excel 200


How to Change the Company Name and User Name in an Office XP Progra


How to Change the Font in a Comment in Excel 2000


How to Change the ODBC Data Source for a PivotTable in Excel 200


How to Change the Voice That Is Used for Text to Speech in Exce


How to Check and Manage the Status of Links in Excel 200


How to Check the Version of Office X


How to Clear the Most Recently Used Files List in an Office XP Program by Modifying the Windows Registry


How to Clear the Most Recently Used List in Office Programs


How to Compare Two Cells Ignoring Leading and Trailing Spaces


How to Configure a Policy Setting to Disable Password Protection for Microsoft Access 2002, Microsoft Excel 2002, and Microsoft Word 2002


How to Configure a Policy Setting to Disable the "Office on the Web" Command in Office XP


How to Configure a System Policy to Control the Recently Used File List in an Office XP Program


How to Consolidate Multiple Worksheets to a Single Sheet in Excel 2000


How to Convert an Add-in File into a Workbook in Excel 2000


How to Convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000


How to Convert Text to Numbers in Microsoft Excel 2002


How to Count Unique Elements in a Cell Range in Excel


How to Create a Column Chart with Two Y-Axes in Excel 2000


How to Create a Form Letter by Using Information from an Excel 2002 Worksheet in Word 2002


How to Create a Normal Chart from a PivotTable in Excel 2000


How to Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000


How to Create a Smart Tag DLL in ATL For Use in Office XP


How to Create a Smart Tag DLL in Visual Basic for Use in Office XP


How to Create a Threaded Discussion in Microsoft Office Application


How to Create an Add-in Application Name and Description in Excel 2000


How to Create an Add-In File in Excel 2000


How to Create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000


How to Create an Excel Macro by Using Automation from Visual Basic .NET


How to Create an Office XP Smart Tag DLL by Using Visual Basic .NET


How to Create an Office XP Smart Tag DLL by Using Visual C# .NET


How to Create Functions to Calculate Light Years in Excel 2000


How to Create Multiple Views and Create and Print a Report in Exce


How to Create Multiple Views, Create and Print a Report in Excel 2000


How to Create PivotTables from Multiple Consolidation Ranges in Excel 2000


How to Create Two Pie Charts in One in Excel 2000


How to Custom Sort or Prevent Auto Sort in PivotTable in Excel 2000


How to Customize the My Places Bar in the "Open" and "Save As" Dialog Boxes


How to Deploy the Office XP Web Components in an Office Progra


How to Determine the Order in Which Shapes Are Added to Diagrams in Office Programs


How to Develop Database-Driven Smart Tags for Office XP by Using Visual Basic for Windows


How to Disable FrontPage 2002 Commands by Using a GPO and a WSH Scrip


How to Disable the Web Toolbar Components in Office XP Programs by Using a System Policy


How to Dismiss a Dialog Box Displayed by an Office Application by Using Visual C++ .NET and MFC


How to Display All Menu Commands in Office XP Programs


How to Display Data as Percentage of the Total in a PivotTable in Excel 2000


How to Display More Digits in Trendline Equation Coefficients in Exce


How to Display or Hide the Ask a Question Box in Microsoft Office


How to Embed and Automate an Excel Worksheet by Using C++ .NET and MFC


How to Export an XML Spreadsheet File into Generic XML in Excel 200


How to Export Data in a DataGrid on an ASP . NET WebForm to Microsoft Exce


How to Export Lotus 1-2-3 Linked Files to Excel 2000


How to Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000


How to Force Excel to Always Reference the Same Cell in Excel 2000


How to Get Windows Status Information from Windows API in Excel 2000


How to Handle Corrupted Excel Files by Saving Them in the SYLK Forma


How to Handle Events for Excel by Using Visual Basic .NET


How to Handle Events for Excel by Using Visual C# .NET


How to Handle Events for Excel by Using Visual C++ .NET


How to Hide Gridlines in a Selected Area of a Worksheet in Excel 2000


How to Hide Records with Duplicate Cell Entries in Excel 2000


How to How to Apply Different Passwords or Permissions to Separate Ranges in Worksheets in Excel 200


How to Identify and Remove PLDT, CAR, and SGV Macro Viruses in Excel 2000


How to Import Data into SQL Server from Exce


How to Include Both Value Labels and Percentage Labels on a Pie Chart in Excel 2000


How to Index Data in a PivotTable in Excel 2000


How to Insert a Picture into the Header or Footer in Microsoft Excel 2002


How to Install or Repair Microsoft Excel Features in Excel 2000


How to Link to a Particular Worksheet from a Web Page in Excel 2000


How to Make Paste Options Disappear After You Paste in Excel 200


How to Manage Office XP Templates in Office Program


How to Modify a Particular Time with the TIME and MOD Functions in Excel 2000


How to Obtain and Install the Excel 2000 SR-1 Eurotool Add-In Update


How to Obtain and Install the Excel 2000 SYLK File Security Update in Excel 2000


How to Open a Document Linked to Password-Protected Sheet in Excel 2000


How to Open Documents from FTP Site and Save Documents to FTP Site with an Office XP Program


How to Optimize PivotTable Performance in Excel 2000


How to Perform a Two-Dimensional Lookup in Excel 2000


How to Plot Values Against a Recommended Range in Excel 2000


How to Preserve Formulas If You Save a Document As a Text File in Excel 2000


How to Prevent Excel from Automatically Opening Files in the Startup Folder in Excel 200


How to Query and Display Excel Data by Using ASP.NET, ADO.NET and Visual Basic .NET


How to Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET


How to Rank Duplicate Values Sequentially in Excel 2000


How to Remove Entries from Add-Ins Dialog Box


How to Remove Password Protection from Worksheets, Workbooks, and Shared Workbooks in Excel 2000


How to Remove Template Listings in Excel


How to Rename a Chart by Using the Name Box in Excel 2000


How to Reset Personal Menus in Office XP and Office 2000 Programs


How to Retrieve the Names of Macros from an Excel Workbook by Using Visual Basic 6.0


How to Run Office Macros by Using Automation from Visual C# .NET


How to Save a Workbook as a Web Page in Excel 2002


How to Save Files in Other Formats in Excel 2000


How to Save Files in Other Formats in Excel 2002


How to Send Form Results to a Microsoft Excel Worksheet Using FrontPage 2000


How to Set a Print Area by Using a Defined Name in Excel 2000


How to Set Up and Use the RTD Function in Excel 2002


How to Simulate a PivotTable with No Summarization in Excel 2000


How to Sort Cells Without Sorting Linked Cells in Excel 2000


How to Sort More Than Three Columns in Excel 2000


How to Specify Dynamic Web Query Parameters in Excel 2000


How to Specify Trusted Sources for Digital Certificates in Excel 2002, PowerPoint 2002, and Word 2002


How to Suppress #DIV/0! Error Value in Division in Excel 2000


How to Suppress the Printing of Errors in Workbook Cells in Excel 2002


How to Transfer Data to an Excel Workbook by Using Visual Basic .NET


How to Transfer Data to an Excel Workbook by Using Visual C# .NE


How to Transfer Data to Excel by Using SQL Server Data Transformation Service


How to Transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET


How to Transfer XML Data to Microsoft Excel 2002 by Using Visual C# .NET


How to Transform a DataSet to Spreadsheet XML for Excel by Using Visual Basic .NET and ASP .NET


How to Troubleshoot Custom Smart Tags in Office XP


How to Troubleshoot Speech Recognition Problems in Word 2002


How to Turn AutoComplete On or Off in Excel 2000


How to Turn Off Function Argument ToolTips in Excel 2002


How to Turn Off the Message for Updating Links in a Workbook in Excel


How to Use a Web Data Source for a PivotTable in Excel 2000


How to Use Addresses from an Access 2002 Database Create Labels in Word 2002


How to Use Addresses from an Excel 2002 Worksheet to Create Labels in Word 2002


How to Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET


How to Use Advanced Filter to Exclude Records in Excel 2000


How to Use Automation to Create Office Command Bars and Controls by Using Visual C++ .NET


How to Use AutoSave in Excel 2000


How to Use Custom Toolbars from Excel 5.0 in Excel 2000


How to Use Dates and Times in Excel 2000


How to Use Draw Border Tools and Draw Border Grid Tools to Apply and Remove Cell Borders in Excel


How to Use Excel Startup Folders in Excel 2000


How to Use Excel Startup Folders in Excel 2002


How to Use Find to Search Multiple Worksheets in Excel 2000


How to Use Functions in Formulas in Excel 2000


How to Use Global and Local References in Formulas in Excel 2000


How to Use Keyboard Shortcuts to Select Border Styles in Excel


How to Use Lotus 1-2-3 Commands to Attach Text Data Labels to a Chart in Excel 2000


How to Use Microsoft Map to Display Postal Code Centers in Excel 2000


How to Use Microsoft Map to Display Specific States and Nations in Excel 2000


How to Use Natural Language Formulas in Excel 2000


How to Use NETWORKDAYS with Multiple Holidays in Excel 2000


How to Use New "Find and Replace" Dialog Box in Excel 2002


How to Use Only Selected Parts of AutoFormat in Excel 2000


How to Use RAND() to Generate Randomly Distributed Integers in Excel 2000


How to Use Shared Workbooks with Different Versions of Excel, Including Excel 2000


How to Use Small Business Financial Manager in Excel 2002


How to Use Speech Recognition to Select Cells, Rows, and Columns in Excel


How to Use STDEV or STDEVP with a PivotTable in Excel 2000


How to Use SUM Function on Only Odd or Even Rows in Excel 2000


How to Use Text-to-Speech in Excel 2002


How to Use the "Most Recently Used" Category in the Function Wizard in Excel 2000


How to Use the "Send To" Menu Command to Send Worksheets and Workbooks as E-Mail in Excel


How to Use the AutoCorrect Options Smart Tag in Excel 2002


How to Use the AutoRepublish Feature in Excel 2002


How to Use the Chart Wizard in Excel 2000


How to Use the Error Checking Options Button in Excel 2002


How to Use the Excel Formula Evaluator in Excel 2002


How to Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000


How to Use the Forms Controls on a Worksheet in Excel 2000


How to Use the Forms Controls on a Worksheet in Excel 2002


How to Use the GetPivotData Worksheet Function in Excel 2000


How to Use the Histogram Add-in in Excel 2000


How to Use the HTML Filter in Word 2000


How to Use the INDEX and LINEST Functions to Solve for New X-Values in Excel 2000


How to Use the Keyboard to Change the Active Cell in Excel 2000


How to Use the Microsoft Office Application Recovery Tool in Office XP Program


How to Use the Paste Options Buttons in Excel 2002


How to Use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000


How to Use the Template Wizard with Data Tracking Add-In in Excel 2000


How to Use the Undo Feature with Inserted Objects in Office XP Program


How to Use Visual Basic .NET for Binding for Office Automation Servers


How to Use Visual C# .NET to Automate a Running Instance of an Office Program


How to Use Wildcard Characters in Microsoft Excel 2000 Parameter Queries


How to View the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly


How to Work with an HTML Table That Contains Merged Cells in Excel 2000


How to Work with Serial Number Dates and Julian Dates in Microsoft Excel 2000


XL: How to Add a New Category to Function Category List


XL: How to Add Data to a Drop-Down or List Box


XL: How to Add MS Excel 5.0 Dialog Sheet to a Workbook


XL: How to Add New Data to a Data Map Chart


XL: How to Add the Workbook Path to the Footer


XL: How to Add Totals to a Stacked Column Chart


XL: How to Analyze Questionnaire or Survey with a PivotTable


XL: How to Append an Excel Worksheet to a Database Using DAO


XL: How to Assign a Macro to an Option Button


XL: How to AutoFilter Records Based on Cell Formatting


XL: How to Avoid "Save Changes?" When You Close a Workbook


XL: How to Bypass the Text Import Wizard When You Import File


XL: How to Calculate Compound Interest


XL: How to Calculate Compound Interest for an IntraYear Period


XL: How to Calculate the Number of Days in a Month


XL: How to Call a Macro Repeatedly on a Fixed Time Interval


XL: How to Change Arabic Page Numbers to Roman Numerals


XL: How to Change Chart Type of a Series in Combination Chart


XL: How to Change Connection Information for a Query


XL: How to Change Default Font and Font Size in Microsoft Excel


XL: How to Change the Alternate Startup Folder (Directory)


XL: How to Change the Case of Text


XL: How to Check Number of Records Returned in an AutoFilter


XL: How to Check Spelling for Worksheet Objects Only


XL: How to Close All Workbooks but One with Visual Basic Macro


XL: How to Combine Cells of Information in Excel


XL: How to Compare Data in Two Columns for Duplicates


XL: How to Compute the Average Growth Rate of an Investment


XL: How to Compute the Periodic Annual Interest Rate in Microsoft Excel


XL: How to Concatenate DDE to MSQuery Statements


XL: How to Consolidate Multiple Worksheets to a Single Sheet


XL: How to Continue a Visual Basic Statement from One Line to the Next


XL: How to Control the AutoFilter with a Macro


XL: How to Convert a Numeric Value into English Words


XL: How to Convert Text to Numbers


XL: How to Copy Files from Cabinets on DMF-Formatted Disk


XL: How to Copy One of Each Record Type to Another Worksheet


XL: How to Copy Text to TextBoxes Using the Characters Method


XL: How to Copy the Text Within a Text Box to a Cell


XL: How to Correct Rounding Errors in Floating-Point Arithmetic


XL: How to Count Blank Cells in a Specified Range


XL: How to Count Cells That Contain Formulas, Text, or Numbers


XL: How to Count Rows Displayed After Data Has Been Filtered


XL: How to Count the Occurrences of a Number or Text in a Range


XL: How to Create a Bell Curve Chart


XL: How to Create a Biorhythm Chart


XL: How to Create a Bullet List in Microsoft Excel


XL: How to Create a Chart with Discontiguous Ranges


XL: How to Create a Column Chart with Two Y Axe


XL: How to Create a Conditional Format to Hide Errors


XL: How to Create a Dynamic Named Range


XL: How to Create a Formula to Correctly Evaluate Blank Cells


XL: How to Create a Gantt Chart Using Hours as the Scale


XL: How to Create a Gantt Chart Using Hours as the Scale


XL: How to Create a Macro That Counts Comments


XL: How to Create a Macro That Counts Text Notes (Cell Notes)


XL: How to Create a Macro That Opens Multiple Selected Files


XL: How to Create a Map with Microsoft Data Map


XL: How to Create a Monthly Calendar


XL: How to Create a Single Stacked Column or Bar Chart


XL: How to Create a Spiral Chart


XL: How to Create a User-Defined Chart Format


XL: How to Create a User-Defined Chart Format


XL: How to Create Add-in Application Name and Descriptio


XL: How to Create an Auto_Open Macro to Show Data Form Dialog Box


XL: How to Create an Index with Microsoft Query


XL: How to Create and Use an Auto_Close Procedure


XL: How to Create and Use One-Input Data Tables in Microsoft Excel


XL: How to Create and Use Two-Input Data Tables in Microsoft Excel


XL: How to Create Application-Level Event Handlers


XL: How to Create Data Validation Circles for Printing


XL: How to Create Functions to Calculate Light Years


XL: How to Create MS Access Database from MS Excel Using DAO


XL: How to Create Multiple Views and Create and Print a Report


XL: How to Create PivotTables from Multiple Consolidation Ranges


XL: How to Create Yes and No Buttons for a Custom Message Box


XL: How to Delete and Restore a Menu That Has a Submenu


XL: How to Determine How Many Pages Will Be Printed


XL: How to Determine How Many Pages Will Be Printed


XL: How to Determine If a File Is Read-Only


XL: How to Determine If a Variable Is an Array


XL: How to Determine If a Workbook or a Worksheet Is Protected


XL: How to Determine Top/Bottom Used Cells in a Sparse Array


XL: How to Display a Progress Bar with a User Form


XL: How to Display Data as Percentage of Total in Pivot Tabl


XL: How to Display Only Certain States/Nations in Microsoft Map


XL: How to Display Postal Code Centers in Microsoft Map


XL: How to Display the "What's New in Excel" Windo


XL: How to Display the Current Date and Time with Text


XL: How to Display the File Name of a Worksheet Without Using a Macro


XL: How to Display the Open and Save As Dialog Boxes


XL: How to Display Top 10 Records with a Macro


XL: How to Enable AutoSave


XL: How to Enter a Second Line in a Message Box


XL: How to Extract an Exact Match of Text from a Database


XL: How to Find and Replace Tildes and Wildcard Characters


XL: How to Find Resources on Microsoft Excel Solver


XL: How to Find Secant, Cosecant, or Cotangent of an Angle


XL: How to Find Technical Information About Microsoft Excel


XL: How to Find the Percentage of Change Between Values


XL: How to Find Visual Basic for Applications Help


XL: How to Force Macro Code to Wait for Outside Procedure


XL: How to Get Prime Numbers or Factors


XL: How to Hide Records with Duplicate Cell Entries


XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro


XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro


XL: How to Identify and Remove PLDT/CAR/SGV Macro Viruses


XL: How to Index Data in a PivotTable


XL: How to Insert a Graphic File in Microsoft Excel Workshee


XL: How to Lock Individual Cells in a Workshee


XL: How to Make Spinner Whose Minimum Value Is Less Than Zero


XL: How to Make Sure That Only Numbers Are Entered in a Column


XL: How to Manage Multiple Windows in Excel


XL: How to Minimize Metadata in Microsoft Excel Workbooks


XL: How to Modify the Number of Undo Levels


XL: How to Obtain the SQL Statement for a PivotTable


XL: How to Open a Copy of a Template in MS Excel 7.0, 97


XL: How to Parse Data Using the Text To Columns Command


XL: How to Parse Data Using the Text To Columns Command


XL: How to Perform a Case-Sensitive Lookup


XL: How to Play a Sound Note Using Visual Basic for Applications


XL: How to Play Sounds Using Visual Basic for Applications


XL: How to Populate an Array with a Discontiguous Range


XL: How to Preserve Formulas When Saving as a Text File


XL: How to Prevent File Corruption


XL: How to Programmatically Disable Microsoft Excel Control Menu Commands


XL: How to Programmatically Print All Embedded Charts on a Worksheet


XL: How to Programmatically Reset a Workbook to Default Styles


XL: How to Programmatically Save a File to a Network Drive


XL: How to Programmatically Save a File to a Network Drive


XL: How to Put Folder Contents into a Worksheet


XL: How to Rank Duplicate Values Sequentially


XL: How To Recover MS Excel File If Unwanted Changes Are Made


XL: How to Remove Duplicate Records or Create List of Unique Records


XL: How to Remove Gridlines from a Section of a Worksheet


XL: How to Remove User-Defined Functions from Function Wizard


XL: How To Retrieve a QueryDef from MS Access Using DAO


XL: How to Retrieve a Table from Access into Excel Using DAO


XL: How to Retrieve Records into Specific Columns Using DAO


XL: How To Retrieve the Results of a Parameter Query Using DAO


XL: How to Return Data from a Dialog Box to a Worksheet


XL: How to Return the First or Last Match in an Array


XL: How to Return the Nth Word from a String


XL: How to Reverse the Axis on a Bar Chart


XL: How to Run a Macro When Certain Cells Change


XL: How to Run a Macro When Certain Cells Change


XL: How to Run a WordBasic Macro from an MS Excel Macro


XL: How to Save Personal Macro Workbook When Excel Is Open


XL: How to Scroll Window Views from Object to Object


XL: How to Select Cells/Ranges Using Visual Basic Procedures


XL: How to Select Ranges Using Visual Basic for Applications (Novice Examples)


XL: How to Select the Current Region Minus the First Row


XL: How to Set Page Setup Attributes for More Than One Sheet


XL: How to Set Page Setup Attributes for More Than One Sheet


XL: How to Set Print Area to Range with Defined Name


XL: How to Set Print Areas and Print Titles on a Worksheet


XL: How to Set the Descriptive Name of an Add-in File


XL: How To Share a Custom AutoFill List


XL: How to Show Quotation Marks in Function Results and Macros


XL: How to Simulate a PivotTable with No Summarization


XL: How to Solve for New X-Values Using INDEX and LINEST


XL: How to Sum a Range of Cells Based on a Number Format


XL: How to Sum and Format a Range of Hours, Minutes, or Seconds


XL: How to Sum Either Odd or Even Rows Onl


XL: How to Sum Ranges Using Visual Basic for Applications


XL: How to Suppress "Save Changes?" Prompt When You Close a Workbook


XL: How to Troubleshoot Startup Problems in Microsoft Excel


XL: How to Use "On Error" to Handle Errors in a Macro


XL: How to Use a Custom Function in Another Workbook


XL: How to Use a Logical AND or OR in a SUM+IF Statement in Excel


XL: How to Use a Macro to Enter Cell Note Text in a Text Box


XL: How to Use a Toolbar Button to Open a File Indirectl


XL: How to Use a VBA Macro to Sum Only Visible Cells


XL: How to Use Advanced Filter to Exclude Records


XL: How to Use Conditional Formatting to Shade Every Other Row


XL: How to Use DAO in Excel Without Referencing DAO Library


XL: How to Use DAO to Append the Records in Two Tables


XL: How to Use DAO to Create a New Microsoft Excel Workbook


XL: How to Use Dynamic Arrays in a Macro


XL: How to Use File DSNs and DSN-less Connections


XL: How to Use Grouping for Fields in a PivotTable


XL: How to Use Grouping for Fields in a PivotTable


XL: How to Use INDEX and MATCH Worksheet Functions with Multiple Criteria


XL: How to Use Input Boxes with Visual Basic for Applications


XL: How to Use Looping Structures in Visual Basic for Applications


XL: How to Use Microsoft Excel Data Tables to Analyze Information in a Database


XL: How to Use STDDEV or STDDEVP with a PivotTable


XL: How to Use System, User, and File Data Sources


XL: How to Use the Conditional Sum Wizard in Microsoft Excel


XL: How to Use the DataEntryMode Property


XL: How to Use the Forms Controls on a Worksheet


XL: How to Use the FREQUENCY Function


XL: How to Use the Histogram Add-i


XL: How to Use the INDIRECT Function to Create References


XL: How to Use the INDIRECT Function to Create References


XL: How to Use the Left, Right, Mid, and Len Functions in Visual Basic


XL: How to Use the MultiPage Control in a UserForm


XL: How to Use the TabStrip Control in a UserForm


XL: How to Use the Template Wizard with Data Tracking Add-I


XL: How to Use the Virus Search Add-in for Microsoft Excel (WE1280)


XL: How to Use Visual Basic for Applications in Excel


XL: How to Use VLOOKUP or HLOOKUP to Find an Exact Match


XL: How to Work with Random Access Files


XL2000: Files Corrupted on Save: How to Troubleshoot Source of Problem


XL2000: How to a Make Spinner with a Minimum Value Less Than Zero


XL2000: How to Add a Microsoft Excel 5.0 Dialog Sheet to a Workbook


XL2000: How to Add a New Category to Function Category List


XL2000: How to Add the Workbook Path to the Footer


XL2000: How To Add the Workbook Path to the Title Ba


XL2000: How to Assign a Macro to an ActiveX Worksheet Control


XL2000: How to Attach a Custom Toolbar to a Specific Workbook


XL2000: How to Automatically Set Min and Max Scale for Y-Axis


XL2000: How to Avoid Saving Password in Text File When You Get External Data


XL2000: How to Break Links Between a Chart and a Worksheet


XL2000: How to Call a Macro Repeatedly on a Fixed Time Interval


XL2000: How to Change the Date or Time Format in a Header or Footer


XL2000: How to Change the Font in a Cell Comment


XL2000: How to Change the Paper Source Using the SendKeys Command


XL2000: How to Change the Taper Style for All Series in a Chart


XL2000: How to Check Spelling for Worksheet Objects Only


XL2000: How to Close All Workbooks But One with a Visual Basic Macro


XL2000: How to Compare Data in Two Columns for Duplicates


XL2000: How to Continue a Visual Basic Statement from One Line to the Next


XL2000: How to Control the Appearance of the Mouse Pointer While a Macro Runs


XL2000: How to Control the AutoFilter with a Macro


XL2000: How to Control the Placement of Objects


XL2000: How to Convert a Numeric Value into English Words


XL2000: How to Convert All Files on a Server to Microsoft Excel


XL2000: How to Copy One of Each Record Type to Another Worksheet


XL2000: How to Copy Text to Text Boxes Using the Characters Method


XL2000: How to Copy the Text Within a Text Box to a Cell


XL2000: How to Count Rows Displayed After Data Has Been Filtered


XL2000: How to Create a Chart with Non-Contiguous Ranges


XL2000: How to Create a Dynamic Named Range


XL2000: How to Create a Group of Mutually Exclusive ToggleButton Controls


XL2000: How to Create a Macro That Opens Multiple Selected Files


XL2000: How to Create a Monthly Calendar


XL2000: How to Create a Startup Screen with a UserForm


XL2000: How to Create a Template for a Toolbox Control


XL2000: How to Create and Use a Workbook_BeforeClose Procedure


XL2000: How to Create PivotTable from Word


XL2000: How to Create Unique Random Integers Between Two Numbers


XL2000: How to Create Yes and No Buttons for a Custom Message Box


XL2000: How to Customize a Custom Toolbar Button


XL2000: How to Delete a Collection of Code Objects from a VBAProject


XL2000: How to Delete Cells with a For Each...Next Loop


XL2000: How to Determine If a File Is Read-Only


XL2000: How to Determine If a Variable Is an Array


XL2000: How to Determine If a Workbook or a Worksheet Is Protected


XL2000: How to Determine If the Active Cell Contains a Comment


XL2000: How to Determine the Key Pressed Along with Mouse Button


XL2000: How to Determine Which DLLs Are Registered


XL2000: How to Determine Which Items Are Selected in a List Box


XL2000: How to Display a ComboBox List When a UserForm Is Displayed


XL2000: How to Display a Custom Function in Step 2 of the Function Wizard


XL2000: How to Display a Custom Office Assistant Balloon


XL2000: How to Display a UserForm Whose Name Is in a Variable


XL2000: How to Display the Open and Save As Dialog Boxes


XL2000: How to Display Top 10 Records with a Macro


XL2000: How to Dynamically Resize a User Form


XL2000: How to Enter a Second Line in a Message Box


XL2000: How to Fill List Box Control with Multiple Ranges


XL2000: How to Find Open Programs That Are DDE-Capable


XL2000: How to Force Macro Code to Wait for Outside Procedure


XL2000: How to Get Prime Numbers or Factors


XL2000: How to Hide and Restore a Built-In Menu


XL2000: How to Hide Button Controls with Visual Basic for Applications


XL2000: How to Make a Macro That Automatically Starts When You Open a Workbook


XL2000: How to Manually Recalculate a Single Cell or Range


XL2000: How to Move Between Custom UserForms with Command Buttons


XL2000: How to Obtain the SQL Statement for a PivotTable


XL2000: How to Open a Copy of a Template in Microsoft Excel 2000


XL2000: How to Pass Variables in Visual Basic for Applications Macros


XL2000: How to Place a Check Mark Next to a Custom Menu Item


XL2000: How to Play Sounds Using Visual Basic for Applications


XL2000: How to Populate an Array with a Discontiguous Range


XL2000: How to Populate One List Box Based on Another List Box


XL2000: How to Prevent the Automatic Creation of Hyperlinks


XL2000: How to Programmatically Change the Project Name Property


XL2000: How to Programmatically Convert Column Position Numbers to Column Letters


XL2000: How to Programmatically Copy All Range Names


XL2000: How to Programmatically Create a Chart Without Selecting a Range of Cells


XL2000: How to Programmatically Create a Collection


XL2000: How to Programmatically Create a Reference


XL2000: How to Programmatically Delete and Restore a Menu That Contains a Submenu


XL2000: How to Programmatically Delete Defined Names with Links


XL2000: How to Programmatically Disable Keyboard Functionality


XL2000: How to Programmatically Disable Microsoft Excel Control Menu Commands


XL2000: How to Programmatically Display All Files in a Folder


XL2000: How to Programmatically Find the Nth Word in a Text String


XL2000: How to Programmatically Format Names of Months in All-Capital Letters


XL2000: How to Programmatically Increment a Date With a Spinner


XL2000: How to Programmatically Insert Blank Rows in a Worksheet


XL2000: How to Programmatically Insert Data from a List Box into the Active Cell


XL2000: How to Programmatically Make Sure That Only Numbers Are Entered in a Column


XL2000: How to Programmatically Measure the Visible Range in Points


XL2000: How to Programmatically Modify Hyperlink Addresses on a Worksheet


XL2000: How to Programmatically Perform a Web Query


XL2000: How to Programmatically Reset a Workbook to Default Styles


XL2000: How to Programmatically Save All Open Workbooks


XL2000: How to Programmatically Select Every Nth Row in a Range


XL2000: How to Programmatically Select the Current Data Area Without Selecting the First Row


XL2000: How to Programmatically Subtract or Sum Two Ranges of Data


XL2000: How to Programmatically Sum Only the Visible Cells in a Range


XL2000: How to Programmatically Suppress an Error Value Returned by a Formula


XL2000: How to Record a Macro Using Relative Cell References


XL2000: How to Reduce the Chances of Macro Virus Infectio


XL2000: How to Reference a Cell in the Header or Footer


XL2000: How to Remove All Items from a ListBox or ComboBox


XL2000: How to Remove Individual AutoFilter Drop-Down Lists


XL2000: How to Remove Links from a Worksheet


XL2000: How to Remove the Control Menu and Program Window Controls


XL2000: How to Return Data from a Dialog Box to a Worksheet


XL2000: How to Return Multiple Values from a Custom Function


XL2000: How to Return the Address of the Cell with the Largest or Smallest Value


XL2000: How to Return the Source of a Hyperlink in a Cel


XL2000: How to Return Values from a List Box That Displays Multiple Columns


XL2000: How to Run a WordBasic Macro from a Microsoft Excel Macro


XL2000: How to Secure Visual Basic Code in Excel


XL2000: How to Select Cells/Ranges Using Visual Basic Procedure


XL2000: How to Select Ranges Using Visual Basic for Applications (Novice Examples)


XL2000: How to Send Form Mail That Uses Excel Data


XL2000: How to Set the Default Command Button on a UserForm


XL2000: How to Set the Descriptive Name of an Add-in File


XL2000: How To Share a Custom AutoFill List


XL2000: How to Show Quotation Marks in Function Results and Macros


XL2000: How to Simulate a Paused Visual Basic Procedure


XL2000: How to Simulate Combination List-Edit Control for UserForms


XL2000: How to Sum a Range of Cells Based on a Number Format


XL2000: How to Temporarily Hide a UserForm


XL2000: How to Trap Events for an Embedded Chart


XL2000: How to Turn off Shortcut Menus


XL2000: How to Use "On Error" to Handle Errors in a Macro


XL2000: How to Use a Custom Function in Another Workbook


XL2000: How to use a Macro to Enter Cell Note Text in a Text Box


XL2000: How to Use a UserForm for Entering Data


XL2000: How to Use a Visual Basic Macro to Open and Retrieve a File on the Internet


XL2000: How to Use a Visual Basic Macro to Sort Arrays in Excel


XL2000: How to Use ADO to Return Data to a ListBox or ComboBox


XL2000: How to Use Application.Match to Locate Date Values on a Worksheet


XL2000: How to Use DAO to Create a New Microsoft Excel Workbook


XL2000: How to Use Data Access Objects to Join Tables of Different Formats


XL2000: How to Use Data Validation to Prevent Duplicate Entries


XL2000: How to Use Dynamic Arrays in a Macro


XL2000: How to Use EnableEvents to Disable Event Handling


XL2000: How to Use Input Boxes with Visual Basic for Applications


XL2000: How to Use Macros to Set Row Height and Column Width


XL2000: How to Use the ApplyCustomType Method to Format Charts


XL2000: How to Use the Imp Operator for Binary Comparison


XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events


XL2000: How to Use the RefEdit Control with a UserForm


XL2000: How to Use the SelectionChange Event to Make the Active Row Bold


XL2000: How to Use the TabStrip Control on a UserForm


XL2000: How to Use the TextColumn Property


XL2000: How to Use Visual Basic Code to Total Rows and Columns in an Array


XL2000: How to Use Visual Basic Constants in Text Strings


XL2000: How to Use Visual Basic to Create a Dynamic Chart


XL2000: How to Use Visual Basic to Play an AVI File


XL2000: How to Verify the Value of a CheckBox on a UserForm


XL2001: How to Use Dates and Times in Microsoft Excel


XL2002: How to Automate Smart Tags by Using Visual Basic for Applications


XL2002: How to Delete Cells with a For Each...Next Loop


XL2002: How to Determine If Your Workbook Contains Links to External Data


XL2002: How to Mark an Automation Add-In Function as Volatile


XL2002: How to Prevent the Automatic Creation of Hyperlinks


XL2002: How to Programmatically Reset a Workbook to Default Styles


XL2002: How to Programmatically Turn Off the Clipboard Warning Message


XL2002: How to Recover a Lost Worksheet or Lost Version of a Workshee


XL2002: How to Remove Smart Tags from a Workbook


XL2002: How to Select Cells/Ranges Using Visual Basic Procedures


XL2002: How to Select Ranges Using Visual Basic for Applications (Novice Examples)


XL2002: How to Suppress #DIV/0! Error Value in Division


XL2002: How to Use Auto Fill Options Smart Tags


XL2002: How to Use the "Insert Options" Button in Excel 2002


XL97: How to Assign a Macro to an ActiveX Worksheet Control


XL97: How to Change the Depth of a 3-D Surface Chart


XL97: How to Change the Font in a Cell Comment


XL97: How to Change the Font in a Commen


XL97: How to Change the Taper Style for All Series in a Chart


XL97: How to Control the Placement of Objects


XL97: How to Convert All Files on a Server to Microsoft Excel


XL97: How to Convert an Add-in File into a Workbook


XL97: How to Create a Conditional Format to Hide Errors


XL97: How To Create a Dynamic Chart Using Visual Basic


XL97: How to Create a GIF File from a Microsoft Excel Chart


XL97: How To Create a Group of Mutually Exclusive ToggleButtons


XL97: How to Create a Pie Of Pie Chart or a Bar Of Pie Chart


XL97: How to Create a Report Templat


XL97: How to Create a Startup Screen with a UserForm


XL97: How to Create a Template for a Toolbox Control


XL97: How to Create an Add-in File in Microsoft Excel 97


XL97: How to Create Application Level Event Handlers


XL97: How to Create PivotTable from Word


XL97: How to Create Web Query (.iqy) Files


XL97: How to Customize a Custom Toolbar Button


XL97: How to Delete Cells with a For Each...Next Loop


XL97: How to Delete, Restore, and Edit Menu Items Manually


XL97: How to Determine If the Active Cell Contains a Comment


XL97: How to Determine the Key Pressed Along with Mouse Button


XL97: How to Determine Which Items Are Selected in a ListBox


XL97: How to Disable Shortcut Menus


XL97: How to Display a ComboBox List When UserForm Is Displayed


XL97: How to Display a Custom Office Assistant Balloon


XL97: How to Display a Progress Bar with a User Form


XL97: How to Display a UserForm Whose Name Is in a Variable


XL97: How to Display Custom Function in Function Wizard Step 2


XL97: How to Dynamically Resize a User Form


XL97: How to Fill ListBox Control with Multiple Ranges


XL97: How to Import Web Page Tables into Microsoft Excel


XL97: How to Link to a Particular Worksheet from a Web Page


XL97: How to Modify the Number of Undo Levels


XL97: How to Move Between Custom UserForms with CommandButtons


XL97: How to Obtain and Install the Excel 97 SYLK File Security Update


XL97: How to Obtain the Excel 97 Auto Recalculation Patch


XL97: How to Place a Checkmark Next to a Menu Item


XL97: How to Plot Values Against a Recommended Range


XL97: How to Populate One ListBox Based On Another ListBox


XL97: How to Programmatically Change the Format of a User Input After Data Entry


XL97: How to Programmatically Change the Project Name Property


XL97: How to Programmatically Create a Collection


XL97: How to Programmatically Create a Reference


XL97: How to Programmatically Perform a Web Query


XL97: How to Programmatically Reset a Workbook to Default Styles


XL97: How to Programmatically Save a Worksheet as HTML


XL97: How to Record a Macro Using Relative Cell References


XL97: How to Remove All Items from a ListBox or ComboBox


XL97: How to Remove Individual AutoFilter Drop-Down Lists


XL97: How to Rename a Chart Using Name Box


XL97: How to Restore a Built-In Menu


XL97: How to Restrict Numeric Entry to Only One Cell in a Range


XL97: How to Save Files in Other Formats


XL97: How to Simulate a Paused Visual Basic Procedure


XL97: How to Sort Cells Without Sorting Linked Cells


XL97: How to Specify Dynamic Web Query Parameters


XL97: How to Temporarily Hide a UserForm


XL97: How to Trap Events for an Embedded Chart


XL97: How to Turn Off Automatic Font Scaling in All Charts


XL97: How to Use a Toolbar Settings File from a Network Share


XL97: How to Use a UserForm for Entering Data


XL97: How to Use a Web Data Source for a PivotTable


XL97: How to Use Custom Toolbars in Excel5.xlb


XL97: How to Use Data Validation to Prevent Duplicate Entries


XL97: How to Use EnableEvents to Disable Event Handling


XL97: How to Use Excel Startup Folders


XL97: How to Use FileSearch to Fill a Listbox with File Names


XL97: How to Use Natural Language Formulas


XL97: How to Use the ApplyCustomType Method to Format Charts


XL97: How to Use the EFFECT and NOMINAL Functions to Calculate Loan or Mortgage Interest with Intrayear Compounding


XL97: How to Use the GetOpenFilename Method


XL97: How to Use the GetPivotData Worksheet Function


XL97: How to Use the Internet Assistant Wizard


XL97: How to Use the PivotTable AutoShow Feature


XL97: How to Use the PivotTable AutoSort Feature


XL97: How to Use the Query Before and AfterRefresh Events


XL97: How to Use the TextColumn Property


XL97: How to Use Wildcards in Parameter Queries


XL97: How to Verify the Value of a CheckBox on a UserForm


XL97: How to View Sample Chart with the Keyboard


XL98: How to Add the Workbook Path to the Footer


XL98: How to Delete Cells with a For Each...Next Loop


XL98: How to Programmatically Reset a Workbook to Default Styles


XL98: How to Select Chart Subtype by Using Keyboard


XL98: How to Use the Virus Search Add-in for Microsoft Excel 98

Skip to main content