Home > Excel Help Portal > Programming Excel

<<  (Page 6)  Previous              Next  (Page 8)  >>

Programming Excel

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

301. Macro to Extract Data from a Chart In Microsoft Excel, you can retrieve data from a chart even when the data is in an external worksheet or workbook. This is useful in situations where the chart was created from, or linked to, another file that is unavailable or has been damaged... KB#137016. Keywords: Charts, SERIES, Errors, VBA, Macro, Object, Web

 
302. How to Use a UserForm for Entering Data In Microsoft Excel, you can create a custom UserForm that provides a simple interface for entering data. This article includes steps for creating a custom UserForm and a sample Visual Basic for Applications macro that places the data you enter on... KB#161514. Keywords: VBA, Macro, Object, UserForm, Toolbar

 
303. 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

 
304. Comma Separated Values, .CSV files Some HELP items to read more on this subject. File format converters supplied with Microsoft Excel Help - Wizard -- csv: When a CSV file is read in with the .csv extension it will be read in automatically by Excel. The same file with a .txt extension will be processed by the Text Import Wizard and... Keywords: Format, Arrays, VBA, Macro, Files, Window, INDEX

 
305. How to Create a Chart with Discontiguous Ranges When you record a macro to create a chart using discontiguous ranges, the source address of cells used to create the chart is fixed by Microsoft Excel. This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure)... KB#146058. Keywords: Charts, VBA, Macro, Toolbar, Web, Discontiguous

 
306. Unexpected Behavior with Numbers Formatted as Text When you attempt to change the number format of a cell, the number format may not change as you... KB#181226. Keywords: Format, VBA, Macro, Web

 
307. Converting Feet and Inches to decimal feet I have a column of lengths in the format of 12' 6 7/8". How can I convert this to decimal feet? I don't want to split the column into two parts. Then, how can I convert back to feet and inches?. The... Keywords: Format, Errors, VBA, Web

 
308. How to Determine If a File Is ReadOnly This article describes how to determine if a file has an attribute of read- only, and how to determine if a file is opened as read-only using Microsoft Visual Basic for Applications... KB#153058. Keywords: VBA, Macro, Web

 
309. 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

 
310. Coloring within Ranges, Examples This page contains macros and code snippets. Assistance to Install a Macro or User Defined Function Don't know if this is going to go much of anywhere I'm still trying to figure out joining object properties together I notice in XL2000 that sometime in the VB Editor you get hints as to what to type... Keywords: Colors, Format, Formulas, VBA, Macro, Object, User Defined Function

 
311. How to Use Visual Basic Constants in Text Strings Microsoft Visual Basic for Applications includes a number of intrinsic constants that you can use in macro code to insert certain formatting characters, such as tabs, line feeds, and carriage returns. This article contains information about... KB#211774. Keywords: Text Box, Format, Macro, VBA, Web

 
312. Using Calculate Method May Not Calculate Certain Formulas When you calculate values on a worksheet, formulas that refer to cells that contain custom functions may not be calculated... KB#144508. Keywords: Formulas, VBA, Macro, Web

 
313. Saveas, Save each worksheet as a separate workbook As a further aid Sheet1 will be deleted from the new workbook and if an existing sheet {sheet1, sheet2, sheet3} that remains is named the same as the worksheet name then it also will be deleted before copying in the original sheet to the beginning of the tab... Keywords: Format, Errors, Formulas, VBA, Macro, User Defined Function, VBE, Files, Hyperlinks, Web, Comments

 
314. 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

 
315. How to Display Custom Function in Function Wizard Step 2 In Microsoft Excel 97 for Windows, you can create a custom Microsoft Visual Basic for Applications function to perform calculations. By default, this custom function will appear in the Function Wizard under the function category called User... KB#189165. Keywords: Formulas, VBA, Macro, Toolbar, Web

 
316. How to Sum a Range of Cells Based on a Number Format This article includes a sample Microsoft Visual Basic for Applications custom function that sums the values in a range of cells that are formatted with a specific custom number... KB#164317. Keywords: Custom Number Formats, VBA, Web

 
317. Branching to Other Sections of Code with GoTo and Call In Microsoft Excel versions 5.0 and later, you can use the GoTo and Call statements to branch to other sections of a Microsoft Visual Basic for Applications procedure. NOTE : In earlier versions of Excel, you can do this with the GOTO() and... KB#213486. Keywords: VBA, Web

 
318. How to Return the Address of the Cell with the Largest or Smallest Value This article demonstrates two ways that you can find the address of the cell containing the largest or smallest value in a range of cells in a Microsoft Excel worksheet. If you are using a single row or column of data, you can use a worksheet... KB#213375. Keywords: Formulas, VBA, Web, CELL, OFFSET, MATCH, MAX, MIN

 
319. How to Obtain BuiltIn Constant Values for an Office Application Microsoft Office applications can act as ActiveX Servers. They provide client applications design-time access to an Object library, or type library, that enables client applications to view an Office application's objects, properties, methods,... KB#239930. Keywords: ActiveX, DLL, Microsoft Access, Errors, Class, VBA, Object, Files, HTML, Window

 
320. Excel Automation Fails Second Time Code Runs While running code that uses Automation to control Microsoft Excel, one of the following errors may occur: With Microsoft Excel 97 and later, you receive the error: Run-time error '1004': Method 'name of... KB#178510. Keywords: OLE, Errors, VBA, Object, Window

 
321. Excel as Gridpaper for Drawing I always knew that Excel could be used to create some amazing drawings, but this week's tip shows some new uses for Excel. These ideas are from Don Heckerman a former associate from my days at Telxon. Don is now the head of I.T. infrastructure in the Americas for a global logistics company. He... Keywords: Days, Borders, Fonts, Patterns, Sounds, VBA, Toolbar, Web, Column Width

 
322. How to Set Page Setup Attributes for More Than One Sheet By default, page setup attributes, such as margins, sheet orientation, and print titles, are set individually (on a worksheet-by-worksheet basis). However, you can set some of these attributes globally by using any of the following methods: Use... KB#154663. Keywords: Format, Page Setup, Printing, VBA, Macro, Object, Templates, Toolbar, Web

 
323. Macro to Obtain a List of Paper Names Supported by the Active Printer There is no built-in feature in Microsoft Visual Basic for Applications to obtain a list of paper names (Letter, Legal, A4, and so forth) supported by the active printer. This article contains Visual Basic for Applications sample code that returns... KB#229718. Keywords: API, VBA, Macro, Web

 
324. How to Temporarily Hide a UserForm In versions of Microsoft Excel earlier than Excel 97, if you use the Hide method to hide a custom dialog box, Excel does not hide the dialog box until the macro that contains the Hide method is finished running. In Excel 2000, if you use the... KB#213744. Keywords: Text Box, Command Button, VBA, Macro, UserForm, Web

 
325. Procedure to Export Text File with Comma AND Quote Delimiter Microsoft Excel does not have a menu command to automatically export data to a text file so that the text file is exported with both quotation marks and commas as delimiters. For example, there is no command to automatically create a text file... KB#123183. Keywords: Export, Errors, Printing, VBA, Iteration, Macro, File Name, Menu Command, Text Files, Web

 
326. Sample Macro to Import Data with More Than 256 Fields or Columns Microsoft Excel spreadsheets have 256 columns (column IV). Therefore, Excel cannot accept data with more than 256 fields per record on a worksheet. When you attempt to manually import data from a database or text file that has more than 256 fields... KB#272729. Keywords: Import Data, Format, Errors, Macro, VBA, File Name, Text Files, Web

 
327. How to Use a UserForm for Entering Data In Microsoft Excel, you can create a custom UserForm that provides a simple interface for entering data. This article includes steps for creating a custom UserForm and a sample Microsoft Visual Basic for Applications macro that places the data... KB#213749. Keywords: Text Box, Command Button, VBA, Macro, Object, UserForm, Web

 
328. Macro to Obtain a List of Paper Names Supported by the Active Printer There is no built-in feature in Microsoft Visual Basic for Applications to obtain a list of paper names (Letter, Legal, A4, and so forth) supported by the active printer. This article contains Visual Basic for Applications sample code that returns... KB#244639. Keywords: API, VBA, Macro, Web

 
329. 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

 
330. Macro Doesn't Function on Multiple Sheets in Group Mode In Microsoft Excel, when you use a Microsoft Visual Basic for Applications procedure to perform an action while worksheets are selected in group mode, the action performed may only be performed on one of the worksheets instead of on every worksheet... KB#126313. Keywords: Arrays, VBA, Object, Menu Command, Web, Window

 
331. How to call a Visual Basic .NET Class Library from Visual Basic for Applications in Microsoft Office Use this step-by-step guide to call a .NET class library from Visual Basic for Applications. This sample shows how a Visual Basic for Applications program can use a Visual Basic .NET class library to encrypt and decrypt a string. You can use... KB#317535. Keywords: DLL, Arrays, Class, VBA, Macro, Web

 
332. Sample Macro to Remove User Name from Comment By default, the text of a cell comment contains the user name in the first line of the comment. There is no built-in feature that automatically disables inserting the user name in the comment text. However, you can use a Visual Basic for... KB#213766. Keywords: AutoShapes, Colors, Fonts, Patterns, VBA, Macro, Web, Comments

 
333. Chart and Graph Tutorial Using Custom Chart Markers in XY Chart When you have an XY chart with many data points, the standard chart markers can become too large to show your data. Here is a simple procedure to replace the standard XY chart markers with a smaller marker. Animated Line Chart You can use the Wait method in... Keywords: Bar Chart, Charts, GANTT, Plot, SERIES, Time Series, Trend line, Forecasting, Sales, Format, Formulas, PivotTables, Object, VBA, Links

 
334. How to call Excel Functions from Within Microsoft Access 2000 This article shows you how to use Automation to call Microsoft Excel functions from within Microsoft Access. Microsoft Excel has some functions that Microsoft Access does not have, for example, statistical functions and add-in functions. By... KB#198571. Keywords: Add-In, Microsoft Access, VBA, Macro, Object, LCM

 
335. How to Use the Left, Right, Mid, and Len Functions in Visual Basic This article contains examples of how to manipulate text strings using the Left , Right , Mid , and Len functions in Microsoft Visual Basic for Applications in Microsoft... KB#213646. Keywords: VBA, Macro, Web

 
336. 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

 
337. Read-Only in Excel, Problems with Before you open the file check to see if the read-only attribute is turned on by right-clicking on the file and checking properties. If the file had been copied by copy/paste to a CD-Writer then the read-only attribute gets turned on. XCOPY turns off the read-only attribute so such files are not a... Keywords: Errors, Password, VBA, Macro, Error Message, Files, Toolbar, Web, Comments

 
338. How to Use a Toolbar Button to Open a File Indirectly In Microsoft Excel, you can indirectly associate a workbook with a custom button in another workbook by assigning a macro in the associated workbook to the button. For example, if you have a workbook named My Workbook that contains a button, you... KB#142585. Keywords: VBA, Macro, Toolbar

 
339. How to Return the Source of a Hyperlink in a Cell This article demonstrates how to use Microsoft Visual Basic for Applications (VBA) to programmatically obtain the source address (cell reference) of a... KB#274159. Keywords: Defined Name, VBA, Hyperlinks, Web, Window

 
340. Visual Basic Macro Examples for Working with Arrays This article contains sample Microsoft Visual Basic for Applications procedures that you can use to work with several types of... KB#291069. Keywords: Arrays, VBA, Macro, Web, Comments

 
341. How to Create an Excel Histogram by Using Automation and Analysis ToolPak This article provides a sample Visual Basic project that shows how to use the Analysis ToolPak (ATP) to generate a histogram. This article also illustrates basic techniques for implementing and using the Analysis ToolPak add-in library, and... KB#270844. Keywords: Add-In, Analysis ToolPak, Charts, Histogram, Command Button, Macro, Object, VBA, Templates, Web

 
342. Sample Macro to Sort List Based on Custom Sort Order In Microsoft Excel, you can create your own custom sort lists and you can use these lists to specify sort orders when you sort a list of information. This article describes the procedures for creating a custom sort list and includes a sample... KB#213625. Keywords: Sorting, VBA, Macro, Web

 
343. How to Avoid "Save Changes?" When You Close a Workbook In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro that suppresses the Save Changes? prompt when you close a workbook. You can do this either by specifying the state of the workbook's Saved property or by... KB#129153. Keywords: VBA, Macro, Web

 
344. How to Display a Custom Function in Step 2 of the Function Wizard In Microsoft Excel 2000, you can create a custom Microsoft Visual Basic for Applications function to perform calculations. By default, this custom function appears in the Function Wizard under the function category called User Defined. You can... KB#213183. Keywords: Formulas, VBA, Macro, Web

 
345. Macro to Check for Page Breaks on a Worksheet In Microsoft Excel 2000, you can check for an automatic or manual page break in the current cell by using the PageBreak property in a Microsoft Visual Basic for Applications... KB#213831. Keywords: VBA, Macro, Web

 
346. 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

 
347. Macro Code to Check Whether a File Is Already Open When you use a file that is shared over a network, you may frequently find it useful to know if another user has the file open. The following Microsoft Visual Basic for Applications procedure is an example of a method for determining whether... KB#213383. Keywords: Errors, VBA, Macro, Web

 
348. Use event handlers to simplify time input This week's question comes from John stationed in Okinawa. I am building a spreadsheet to reflect departures and arrivals. There will be basically three cells: Actual Time of Departure, EstimatedTime Enroute, and Estimated Time of Arrival. I would like for the user to just be able to enter (for... Keywords: Format, Formulas, VBA, Macro, Web, Window

 
349. Date Returned in a Macro Is Four Years Too Early When you run a macro that uses a date from a worksheet cell, the date returned by the macro may be four years and one day earlier than the actual... KB#213593. Keywords: Dates, Years, VBA, Macro, Web

 
350. How to Simulate a Paused Visual Basic Procedure There is no built-in method for pausing a macro in Microsoft Excel. This article discusses a method for pausing a macro to allow user input, and then continuing when the user clicks a... KB#213745. Keywords: Borders, Format, Outline, Styles, VBA, Macro, Object, Toolbar, Web, Window

 

<< (Page 6)  Previous              Next  (Page 8) >>