Home > Excel Help Portal > Excel Worksheets

<<  (Page 1)  Previous              Next  (Page 3)  >>

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.

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

 
52. 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... KB#213529. Keywords: Class, VBA, Macro, Object, VBE, Web, Window

 
53. Pointer Is an Hourglass When You Display a Message Box When you run a Visual Basic for Applications macro in Microsoft Excel 97, if the macro uses the MsgBox function to display a message box on the screen, the pointer may appear as an hourglass or as the arrow pointer. When you dismiss the message... KB#159964. Keywords: VBA, Macro, Toolbar, Web, Window

 
54. How To Create a Group of Mutually Exclusive ToggleButtons This article provides an example of how to create a group of mutually exclusive ToggleButton controls on a... KB#166252. Keywords: VBA, UserForm, Toolbar, Web, Window

 
55. Workbooks Containing User Forms Take Excessively Long Time to Save Across WAN Connections When you save Excel workbooks that contain user forms, it typically takes about one minute to save to the local computer or within the local area network (LAN). When you save the same workbooks over a wide area network (WAN), it can take an... KB#254733. Keywords: VBA, Object, Web, Window

 
56. How to Reference a Cell in the Header or Footer This article contains a sample Microsoft Visual Basic for Applications macro that references a cell to the header or footer of a... KB#273028. Keywords: Printing, VBA, Macro, Object, Setup, Web, Window

 
57. How to Map Imported Files into Outlook Using Excel Microsoft Outlook 98 does not have the Field Mapping feature found in Microsoft Outlook 97. This article describes how to use Microsoft Excel as an interim step to conveniently map fields from another database into Outlook 98. This import... KB#189181. Keywords: Export, Format, Patterns, Files, Window

 
58. How to Verify the Value of a CheckBox on a UserForm In Microsoft Excel, a CheckBox control on a UserForm can have one of three values: True , False , or Null . This article contains a sample macro that programmatically retrieves the value of a CheckBox... KB#213760. Keywords: VBA, Macro, UserForm, Web, Window

 
59. How to Create a Group of Mutually Exclusive ToggleButton Controls This article provides an example of how to create a group of mutually exclusive ToggleButton controls on a... KB#213714. Keywords: VBA, UserForm, Web, Window

 
60. DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update Client applications can use Dynamic Data Exchange (DDE) to issue a macro RUN command to Excel 2002. This command may stop working after you update to Service Pack 3 or the Security Update that is listed below. To the client application, the... KB#821137. Keywords: DDE, Errors, Macro, VBA, Window

 
61. How to Add the Workbook Path to the Footer This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that adds the workbook path and file name to the footer of a... KB#213615. Keywords: Printing, VBA, Macro, Object, Setup, File Name, Web, Window

 
62. How to Verify the Value of a CheckBox on a UserForm In Microsoft Excel, a CheckBox control on a UserForm can have one of three values: True, False or Null. This article contains a sample macro that programmatically retrieves the value of a CheckBox... KB#161326. Keywords: VBA, Macro, UserForm, Web, Window

 
63. How to Programmatically Disable Microsoft Excel Control Menu Commands This article describes how to programmatically delete the commands on the Microsoft Windows Control menu (right-click the Microsoft Excel title bar) and disable the Windows control buttons in the upper-right corner of the Excel... KB#213502. Keywords: VBA, Macro, Menu Command, Web, Window

 
64. No Thumbnails Are Displayed When You Search for Clips in Web Collections When you use Microsoft Clip Organizer to search Web Collections for clips, you may be unable to view the thumbnail images of the clips as expected. A generic Windows icon, or another program icon, is displayed in the thumbnail instead of a preview... KB#305211. Keywords: Download, Third-Party, Errors, Files, Web, Window

 
65. How to Populate an Array with a Discontiguous Range To populate an array using Microsoft Visual Basic for Applications in Microsoft Excel, you need to iterate through the range object to populate an array with the data if the range object is discontiguous (whether it is a selection, range name, or... KB#149831. Keywords: Arrays, VBA, Iteration, Macro, Object, Web, Discontiguous

 
66. How to use a macro from the web Bob asked this week's question. I have a problem. The Microsoft Knowledge Base offers a macro to fix the problem, but I can not figure out how to use it. Excellent question. There are lots of sites on the Internet offering help, but they all assume you know the basics about macros. Here is a... Keywords: Clipboard, Macro, VBA, Web, Comments, Window

 
67. Comments Appear in the Wrong Place in Workbook Saved As Web Page When you save an Excel workbook as a Web page, and then view the Web page in your Web browser, comments may appear in the wrong place. For example, a comment may appear in a lower place on the page, where the next comment should... KB#820432. Keywords: Dates, File Name, Files, Web, Comments

 
68. How to Return Values from a List Box That Displays Multiple Columns You can display more than one column of data in a ListBox control on a UserForm. However, when you select an item from the list, only the value from the column that you are binding to is returned. This article provides an example of how to... KB#213723. Keywords: VBA, UserForm, Web, Window

 
69. How to Use the TextColumn Property You can use the TextColumn property of the ListBox or ComboBox control to display one set of values to your user in a list, but to return another value based on the selection that the user... KB#165570. Keywords: Format, VBA, UserForm, Toolbar, Web, Window

 
70. How to change Default Colors in Excel 2000 This step-by-step article describes how to change the default colors in Microsoft Excel for items such as the worksheet tabs, sheet background, and worksheet tab fonts. Because Excel uses Microsoft Windows colors for several of its elements, you... KB#264582. Keywords: Borders, Colors, Fonts, Format, Gridlines, Comments, Window

 
71. Filter Test, AutoFilter and Hidden Rows/Columns Not shown but if Columns were hidden they will remain hidden, when filter it turned off. Show ALL in Column A, shows that the hidden rows are no longer... Keywords: AutoFilter, Web, Comments

 
72. How to Use Visual Basic to Play an AVI File This article shows you how to use Visual Basic for Applications to play an Audio Video Interleaved (AVI) file from Microsoft Excel. You can reference an AVI file directly without inserting it as an... KB#213471. Keywords: Styles, VBA, Object, Web, Window

 
73. Sounds Not Converted with Cell Notes When you display a cell comment, the following message may appear at the top of the comment: [Sound not... KB#156200. Keywords: Errors, Sounds, VBA, Macro, Web, Cell Note, Comments

 
74. How to Create a Template for a Toolbox Control The UserForm Toolbox in the Visual Basic Editor contains all of the default controls that you can add to a UserForm. You can also add other custom controls to the default Toolbox . For example, you can add a type of control that is a template for... KB#213770. Keywords: Fonts, Command Button, UserForm, VBA, Templates, Window

 
75. How to Populate an Array with a Discontiguous Range To populate an array using Microsoft Visual Basic for Applications in Microsoft Excel, you need to iterate through the range object to populate an array with the data if the range object is discontiguous (whether it is a selection, range name, or... KB#213797. Keywords: Arrays, VBA, Iteration, Macro, Object, Web, Discontiguous

 
76. Removing the Control Menu and Application Window Controls In Microsoft Excel, you can create a Visual Basic for applications, macro to disable or remove the application window and worksheet... KB#117855. Keywords: Errors, VBA, Macro, Web, Window

 
77. How to Determine the Key Pressed Along with Mouse Button Visual Basic for Applications in Microsoft Excel 2000 incorporates many more events for activating macros. Some of the new events include MouseDown, MouseUp, KeyDown, and KeyUp. One of the arguments returned by these particular events, Shift,... KB#213736. Keywords: Command Button, VBA, Macro, UserForm, Web, Window

 
78. How to Use the TextColumn Property You can use the TextColumn property of the ListBox or ComboBox control to display one set of values to your user in a list, but to return another value based on the selection that the user... KB#213722. Keywords: Format, VBA, UserForm, Web, Window

 
79. How To Delete a Sub Procedure After It Runs Once This article demonstrates how to programmatically delete a Visual Basic for Applications procedure after you run it one... KB#172109. Keywords: VBA, Macro, Object, VBE, Toolbar, Web, Window

 
80. How to Programmatically Change the Project Name Property By default, when you open a new workbook in Microsoft Excel 2000, the Name property for the workbook project is VBAProject (without the quotation marks). This naming convention may cause a problem if you manually or programmatically attempt... KB#213764. Keywords: Errors, VBA, Macro, Object, VBE, Error Message, Web, Window

 
81. How to Create a BIFF5 File BIFF is a file in the Microsoft Download Center that demonstrates how to create a file using the Microsoft Excel Binary Interchange File Format (BIFF) version... KB#150447. Keywords: Download, OLE, Format, Macro, File Name, Files, Comments

 
82. How to Create a Template for a Toolbox Control The UserForm Toolbox in the Visual Basic Editor contains all the default controls that you can add to a UserForm. You can add other custom controls that are installed on your computer. For example, you can add a third type of control that is... KB#160473. Keywords: Fonts, UserForm, VBA, Templates, Window

 
83. How to Determine If the Active Cell Contains a Comment Microsoft Excel 97 no longer uses cell notes; instead Excel 97 uses cell comments. Consequently, the macro code you use to determine whether a cell contains a comment is different. This article discusses ways to programmatically determine whether... KB#158246. Keywords: VBA, Macro, Object, Web, Comments

 
84. How to Make Sure That Only Numbers Are Entered in a Column This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that you can use to ensure that a certain type of data entry occurs. This macro requires a user to enter only numbers in a specific column on a... KB#141181. Keywords: Add-In, Errors, VBA, Macro, Web, Validation

 
85. How to Display a ComboBox List When UserForm Is Displayed When a UserForm is displayed, you can display the list for a ComboBox control by using the Activate event for the UserForm. This article includes an example that uses the DropDown method of a ComboBox and the Activate method of a UserForm... KB#165935. Keywords: VBA, UserForm, Toolbar, Web, Window

 
86. How to Use a Macro to Enter Cell Note Text in a Text Box This article describes how to put the text of a text note (cell note) into a text box. A macro that does this may be especially helpful if you are using Microsoft Excel for the Macintosh, because in this version of Microsoft Excel, you do not have... KB#142119. Keywords: Text Box, VBA, Macro, Web, Cell Note

 
87. How to Programmatically Hide and Unhide the Windows Taskbar Advanced: Requires expert coding, interoperability, and multiuser skills. By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 98 or Microsoft Windows NT 4.0 taskbar. This article shows you how... KB#290150. Keywords: API, VBA, Web

 
88. How to perform a callback into an assembly from a worksheet function Certain functionality in the Microsoft Excel object model and in the Microsoft Word object model is tightly integrated with Microsoft Visual Basic for Applications and is not accessible with COM interop. You must use a Visual Basic for... KB#830467. Keywords: Class, VBA, Object

 
89. How to Programmatically Change the Format of a User Input After Data Entry This article describes sample Microsoft Visual Basic for Applications Sub procedures (macros) that format a cell after data has been... KB#305565. Keywords: Fonts, Format, VBA, Macro, Web, Discontiguous

 
90. How to Restore a BuiltIn Menu When you use the Delete method in a Visual Basic for Applications macro to delete a menu from a built-in menu bar, you cannot restore the menu and all of its associated menu items with one macro command. If you want to delete a menu and then... KB#167382. Keywords: VBA, Macro, Toolbar, Web

 
91. Visual Basic Macro to Concatenate Columns of Data In Microsoft Excel, you can use a macro to concatenate the data in two adjacent columns and display the result in the column to the right of the columns that contain your data. This article contains a sample Microsoft Visual Basic for... KB#213477. Keywords: Formulas, VBA, Macro, Web, Window

 
92. How to Programmatically Change the Project Name Property By default, when you open a new workbook in Microsoft Excel 97, the Name property for the workbook project is VBAProject (without the quotation marks). This naming convention may cause a problem if you manually or programmatically attempt to... KB#161214. Keywords: Errors, VBA, Macro, Object, VBE, Web, Window

 
93. How to use Microsoft Map to Display Specific States and Nations in Excel 2000 In Microsoft Excel 2000, you can use Microsoft Map to limit the states or countries shown on a map to a given list. By default, Microsoft Map includes all the states or countries when it draws a map. Display Specific States and Nations To limit... KB#213880. Keywords: Microsoft Map, Colors, Format, Toolbar, Window

 
94. How to Programmatically Hide and Unhide the Windows Taskbar By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95/98 or Microsoft Windows NT 4.0 taskbar. This article shows you how to create the two functions that you need to hide and unhide the... KB#202099. Keywords: API, VBA, Web

 
95. How to Remove the Control Menu and Program Window Controls In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro to remove or disable the program window and worksheet... KB#213456. Keywords: Errors, VBA, Macro, Web, Window

 
96. Data Validation The answer to this problem is using Data Validation. This feature, introduced in Excel 97 offers a simple way to have a drop down list right in the cell. There is no problem with moving or resizing.This is a great feature to know. I am embarrassed that after 50+ tips of the week, I have never fully... Keywords: ActiveX, Errors, Links, Defined Name, VBA, Web, Validation, Window

 
97. How to Create a Macro That Counts Text Notes (Cell Notes) In Microsoft Excel, you can use a text note when you do not want to display comments on your worksheet or when you want to print comments on a separate sheet. The More Information section of this article contains sample Microsoft Visual Basic... KB#141564. Keywords: Printing, VBA, Macro, Web, Comments

 
98. Preventing UserForm from Being Dismissed with Close Button When you create a UserForm , a Close button is added to the upper-right corner of the UserForm window. To prevent a user from closing the UserForm with the Close button, use the QueryClose event of the UserForm... KB#213713. Keywords: Command Button, VBA, UserForm, Web, Window

 
99. How to Populate One List Box Based on Another List Box This article contains an example of using the selected item in one list box control on a UserForm to determine the list that will populate a second list box... KB#213748. Keywords: VBA, UserForm, Web, Window

 
100. How to Hide and Restore a BuiltIn Menu When you use the Delete method in a Visual Basic for Applications macro to delete a menu from a built-in menu bar, you cannot restore the menu and all of its associated menu items with one macro command. If you want to remove a menu and then... KB#213708. Keywords: VBA, Macro, Object, Web

 

<< (Page 1)  Previous              Next  (Page 3) >>