Home > Excel Help Portal > Excel Worksheets

<<  (Page 4)  Previous              Next  (Page 2)  >>

Excel Worksheets

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to use Microsoft
Excel worksheets.

1. Overview of Visual Basic Editor Debugging Tools The Microsoft Visual Basic Editor provides a rich set of debugging tools that you can use to troubleshoot problems with your Visual Basic for Applications macro code. This article describes some general debugging techniques that you can use to... KB#165517. Keywords: Printing, VBA, Macro, Object, Toolbar, Web, Window, CODE, MODE, CALL

 
2. Description and Examples of Data Validation Data validation is a feature available in Microsoft Excel. It allows you to do the following: Make a list of the entries that restricts the values allowed in a cell. Create a prompt message explaining the kind of data allowed in a cell.... KB#211485. Keywords: Format, Styles, Errors, Formulas, Error Message, Toolbar, Auditing, Validation

 
3. AOL_PROB List of Problems with AOL TOS and Privacy List of problems with AOL Email List of problems with Newsgroups Newsgroups Features added June 1999 Problems with AOL Help Desk and HELP areas Problem with AOL Browser Problem with normal Browsers using AOL 16-bit My System Reply to Marketing Preferences... Keywords: Days, ActiveX, Fonts, Printing, Files, HTML, Internet Explorer, Web, Comments, Window

 
4. How to Work with Random Access Files By itself, a file consists of nothing more than a series of related bytes located on disks. When your application accesses a file, it must make assumptions about what the bytes are supposed to represent (integers, strings, or other data... KB#150700. Keywords: SERIES, VBA, Macro, Files, Web, Window

 
5. Menu Options Tutorial Inserting Automatic Page Breaks You can use the subtotal feature to add a page break after each change in a sort key. Use View Manager to Print Summary and Detail Reports from Same Worksheet To print both summary and detail views of the same worksheet you can use Excel's automatic subtotals and... Keywords: Charts, SERIES, Camera, Criteria, Sorting, Sales, AutoFormat, Gridlines, Outline, Formulas, Printing, Macro, Object, Toolbar, Links, Auditing, Cell Note, Window

 
6. How to Use Microsoft Query to Merge Two Excel Files This article describes how to use Microsoft Query to merge two Microsoft Excel 2000 files. You may want to do this so that you can combine related information into a single file and use it in a Microsoft Word mail... KB#211802. Keywords: Query, Format, Files, Toolbar, Links

 
7. How to Use Looping Structures in Visual Basic for Applications When you create macros or applications in Microsoft Visual Basic for Applications, it is often necessary to run through a section of code several times. Visual Basic for Applications provides several methods with which to repeat, or loop through,... KB#141762. Keywords: Symbol, Errors, VBA, Iteration, Macro, Object, Web, Comments

 
8. How to use Visual Basic .NET for Binding for Office Automation Servers When you automate an application such as a Microsoft Office application, the calls to the properties and methods of the Office application's objects must be connected in some way to those objects. The process of connecting property and method calls... KB#304661. Keywords: Download, Class, VBA, Object, Web, Window

 
9. How to Programmatically Manipulate a UserForm The programming object model in Microsoft Office 97 for Windows allows you to create a custom dialog box (a UserForm) by using a Microsoft Visual Basic for Applications macro. This article contains sample Visual Basic code that creates and... KB#185774. Keywords: Class, VBA, Macro, Object, UserForm, VBE, Web, Window

 
10. How to Obtain the Window Handle for an Office Automation Server by Using Visual Basic .NET This article demonstrates how to obtain the window handle of a Microsoft Office application while automating that application from Microsoft Visual Basic... KB#302281. Keywords: Download, API, Microsoft Access, Class, VBA, Object, Web, Window

 
11. How to Use the MultiPage Control in a UserForm This article explains how to use the MultiPage control in a UserForm and provides a Microsoft Visual Basic for Applications... KB#155374. Keywords: VBA, Macro, Object, UserForm, Web, Window

 
12. How to use the Excel Formula Evaluator in Excel 2002 This step-by-step article explains how to use the new Formula Evaluator feature in Microsoft Excel 2002. When a cell contains a complex formula, you may find it difficult to determine whether or not it returns the correct value, and if not, which... KB#289245. Keywords: Errors, Formulas, Auditing, RAND, CHOOSE

 
13. How to Use Automation to Create Office Command Bars and Controls with Visual Basic .NET This article demonstrates how to automate Excel to create a command bar that contains buttons, drop-down list boxes, combo boxes, and pop-up... KB#303017. Keywords: Download, OLE, Styles, Errors, Class, Combo Box, VBA, Object, Templates, Web, Window

 
14. Sample Macros to Create a Module from an Existing Module, Named Range, or Text File You may want to programmatically insert stored Visual Basic for Applications (VBA) code into a new workbook that you create with the Workbooks.Add method. This may be necessary if you programmatically create new workbooks that you want to contain... KB#245801. Keywords: Export, VBA, Macro, Object, VBE, File Name, Text Files, Web, Window

 
15. How to Show a "Now Processing" Dialog While Macro Runs This article describes how you can display a dialog box while a macro is running in the background. The purpose of displaying a dialog box is to alert the user that the application is busy while your macro is... KB#162257. Keywords: Export, VBA, Macro, UserForm, Window

 
16. How to Run Sample Code from Knowledge Base Articles The Microsoft Knowledge Base contains a number of articles that include sample code for Visual Basic for Applications macros. Many of these macros illustrate basic concepts of programming in Visual Basic for the various Office 2000 applications.... KB#212536. Keywords: VBA, Macro, Templates, Internet Explorer, Web, Comments, Window

 
17. How to Run Sample Code from Knowledge Base Articles The Microsoft Knowledge Base contains a number of articles that contain sample code for Visual Basic for Applications macros. Many of these macros illustrate basic concepts of programming in Visual Basic for Microsoft Office. This article... KB#173707. Keywords: VBA, Macro, Templates, Internet Explorer, Web, Comments, Window

 
18. How to Run Sample Code from Knowledge Base Articles The Microsoft Knowledge Base contains a number of articles that include sample code for Visual Basic for Applications macros. Many of these macros illustrate basic concepts of programming in Visual Basic for the various Office XP programs.... KB#290140. Keywords: VBA, Macro, Templates, Internet Explorer, Web, Comments, Window

 
19. Adding Series to XY (Scatter) Chart with Second X Axis When you add a second series to an xy (scatter) chart, the new values will be added with respect to the same x-axis values as the first series. This article illustrates how to add a second series to an xy scatter chart that utilizes a second set of... KB#115073. Keywords: Charts, Legend, SERIES, Format, Toolbar, Discontiguous

 
20. How to Remove All Items from a ListBox or ComboBox There is no single method that you can use to remove all items from a ListBox or ComboBox control on a UserForm. The method that you use to remove an item depends on whether the ListBox or ComboBox control is bound to a worksheet. This... KB#165632. Keywords: Arrays, VBA, UserForm, Toolbar, Web, Window

 
21. Excel Stops Responding When Subtotals Are Removed When you try to remove subtotals from a cell range in Excel 2002, the program may appear to stop responding (hang) with Excel consuming 100 percent of the processor... KB#324557. Keywords: Dates, Download, Format, File Name, Files, Registry, Web, Validation

 
22. How to set the Mask Property and the Picture Property for an Office 2003 CommandBar Button This step-by-step article describes how to set the Mask and the Picture properties of a Microsoft Office 2003 CommandBar control from a managed code extension that is created with Visual Studio Tools for the Microsoft Office System. The... KB#824017. Keywords: OLE, Colors, Styles, Class, VBA, Templates, Window

 
23. Limitations for Naming Visual Basic Modules In Microsoft Excel, the names of Microsoft Visual Basic for Applications modules are subject to certain limitations. This article explains these limitations and how to avoid problems when module names include illegal... KB#213560. Keywords: Export, Errors, Macro, Object, VBA, Web, Window

 
24. How to Remove All Items from a ListBox or ComboBox There is no single method that you can use to remove all items from a ListBox or ComboBox control on a UserForm . The method that you use to remove an item depends on whether the ListBox or ComboBox control is bound to a worksheet. This... KB#213721. Keywords: Arrays, VBA, UserForm, Web, Window

 
25. How to Display a Progress Bar with a User Form If you have a Microsoft Visual Basic for Applications macro that takes a long time to complete, you may want to give the user an indication that the macro is progressing normally. This article shows you how to create a progress bar with a user... KB#170782. Keywords: Format, VBA, Macro, UserForm, Toolbar, Web, Window

 
26. Swap as in Swap Columns or Swap Rows This page contains some VBA macros. If you need assistance to install or to use a macro please refer to Getting Started with Macros. For more depth see Install a Macro or User Defined Function on my Formula page. Speed and efficiency considerations can be seen in Proper, and other Text changes and... Keywords: Formulas, VBA, Macro, User Defined Function, Web, Comments

 
27. Visual Basic Editor (VBE) Window Project Explorer (ctrl+R) displays a hierarchical list of the projects and all of the items contained and referenced by each project. I have no idea of what options below came with installation, or if anything was changed, and if changed for the better or not. This is what I have.... Keywords: Colors, Fonts, Errors, Class, Object, VBA, VBE, Files, Registry, Text Files, Web, Comments, Window

 
28. How to Display a Progress Bar with a User Form If you have a Microsoft Visual Basic for Applications macro that takes a long time to complete, you may want to give the user an indication that the macro is progressing normally. This article shows you how to create a progress bar with a user... KB#211736. Keywords: Format, VBA, Macro, UserForm, Web, Window

 
29. How to Display Postal Code Centers in Microsoft Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to display postal code centers on inserted maps for the United States, Canada, or the United... KB#192609. Keywords: Microsoft Map, Colors, Fonts, Format, Symbol

 
30. Error Trying to Delete Image, Category in ClipArt Gallery IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the Restoring the Registry Help... KB#173411. Keywords: Errors, Registry, Web, Comments

 
31. How to Use EnableEvents to Disable Event Handling In Microsoft Excel, you can create event handlers, which are Visual Basic for Applications macros that respond to specific events. An event handler can be run by another Visual Basic macro. This article contains an example macro that disables... KB#165867. Keywords: VBA, Macro, Toolbar, Web, Window

 
32. How to create an Excel Macro by Using Automation from Visual Basic .NET This step-by-step article describes how to automate Microsoft Excel from Microsoft Visual Basic .NET to create a workbook that contains a new macro that is associated with a CommandBar button. Steps to Create the Sample Visual Basic .NET... KB#303871. Keywords: Download, Errors, Class, VBA, Macro, Object, VBE, Toolbar, Window

 
33. How to Programmatically Create a Collection New programming functionality in Microsoft Excel 97 allows you to create a collection. A collection is a predefined object that stores groups of related objects. A collection makes it easier to work with the object group. For example, you can use... KB#161215. Keywords: Class, Macro, Object, VBA, Web, Window

 
34. How to create an AddIn File in Excel 2000 This step-by-step article contains detailed information about how to create an add-in (.xla) file in Microsoft Excel 2000. In Excel 2000, the process that you use to create an add-in file is different than the process for versions of Microsoft... KB#211563. Keywords: Add-In, Charts, Password, Macro, VBA, File Name, Comments, Window

 
35. How to Programmatically Create a Collection Programming functionality in Microsoft Excel allows you to create a collection. A collection is a predefined object that stores groups of related objects, making it easier to work with the object group. For example, you can use a For Each... KB#213763. Keywords: Class, VBA, Macro, Object, Web, Window

 
36. How to Create a Column Chart with Two Y Axes In general, a combination or overlay chart must have a second y-axis. However, Microsoft Excel places the column series plotted on the secondary axis in front of the column series plotted against the primary axis. In many cases, the overlay... KB#121819. Keywords: Charts, Plot, SERIES, Sales, Format, Window

 
37. How to Determine Which Items Are Selected in a ListBox This article explains how to retrieve selected items from a ListBox control that allows you to select multiple... KB#161346. Keywords: Arrays, VBA, UserForm, Web, Window

 
38. Highlight, Change Highlighting Excel has a facility to record changes to individual cells and places a black triangular mark in the upper left corner, similar to cell comments which uses a red triangle. If you changed content and had a cell comment, you will see both when you hover over the cell to see cell comments. (below)... Keywords: Colors, Errors, VBA, Macro, Toolbar, Web, Comments, Window

 
39. How to Create Application Level Event Handlers If you want a particular event handler to run whenever a certain event is triggered, you can write an event handler for the Application object. Event handlers for the Application object are global, which means that as long as Microsoft Excel is... KB#158244. Keywords: ActiveX, Class, VBA, Macro, Object, Window

 
40. How to Create ApplicationLevel Event Handlers If you want a particular event handler to run whenever a certain event is triggered, you can write an event handler for the Application object. Event handlers for the Application object are global, which means that as long as Microsoft Excel is... KB#213566. Keywords: ActiveX, Class, VBA, Macro, Object, Window

 
41. How to Use EnableEvents to Disable Event Handling In Microsoft Excel, you can create event handlers, which are Microsoft Visual Basic for Applications macros that respond to specific events. An event handler can be run by another Visual Basic macro. This article contains a sample macro that... KB#213720. Keywords: VBA, Macro, Web, Window

 
42. How to Determine Which Items Are Selected in a List Box This article explains how to retrieve selected items from a list box control that allows the user to select multiple... KB#213759. Keywords: Arrays, Command Button, VBA, UserForm, Web, Window

 
43. How to Use Automation to Get and to Set Office Document Properties with Visual Basic .NET This article illustrates how to automate Microsoft Word with Microsoft Visual Basic .NET to retrieve and to manipulate document properties. Although the sample in this article is specifically written to automate Word, the same concepts can be... KB#303294. Keywords: Download, Styles, VBA, Object, Web, Window

 
44. How to Create Data Validation Circles for Printing In Microsoft Excel, you can use the Circle Invalid Data button on the Auditing toolbar to identify cells containing values that are outside the data validation limits. A red circle is placed around each identified cell. These circles are not... KB#213773. Keywords: Colors, Errors, Printing, VBA, Macro, Object, Toolbar, Web, Auditing, Validation, Window

 
45. How to Fill List Box Control with Multiple Ranges This article contains an example of a macro that fills the list of a list box control on a UserForm with data from multiple cell... KB#213746. Keywords: Arrays, VBA, Macro, UserForm, Web, Window

 
46. How to Programmatically Create a Reference This article provides sample Microsoft Visual Basic for Applications Sub procedures (or macros) that programmatically create and remove a reference to another project. NOTE: This functionality was not available in Microsoft Excel for Windows... KB#160647. Keywords: Class, VBA, Macro, Object, VBE, Web, Window

 
47. How to programmatically delete the Window Control menu commands in Excel 2002 This article describes how to programmatically delete the commands on the Window Control menu (right-click the Excel title bar) and make the window control buttons in the upper-right corner of the Excel window... KB#814562. Keywords: API, VBA, Object, Menu Command, Web, Window

 
48. Status Bar Tools, Options, View: Formula bar, Status bar, Comments and Indicator, objects, Page Breaks, Formulas, Gridlines, Row & column headers, Outline symbols, Zero values, Horizontal scroll bar, Vertical scroll bar, Sheet tabs. Status Bar (#statusbar) The Status bar is at the bottom of the Excel... Keywords: AutoFilter, OLE, Outline, Formulas, Macro, Web, Comments, Validation

 
49. Visual Basic Example for Using a Spin Button with a Date In Microsoft Excel 2000, you can use a SpinButton control on a UserForm to change values on a worksheet or in a Visual Basic procedure. Microsoft Visual Basic for Applications in Excel 2000 provides the ability to attach procedures to object... KB#213224. Keywords: Text Box, Command Button, VBA, Object, Spin Button, UserForm, Web, Window

 
50. How to Create an Addin File in Microsoft Excel 97 In Microsoft Excel 97, the process you use to create an add-in file is different than the process for earlier versions of Microsoft Excel. This article contains detailed information about how to create an add-in (.xla) file in Microsoft Excel... KB#156942. Keywords: Add-In, Charts, Password, Macro, VBA, File Name, Comments, Window

 

<< (Page 4)  Previous              Next  (Page 2) >>