Visual Basic Archives Page 60

-       Selva V Pasupathy , Hyderabad, India

   590. Sample UserDefined Function to Hide Formula Errors Some formulas in Microsoft Excel return error values under certain conditions. For example, when you use a division formula that multiplies a number by zero, you receive the following error value: #D IV/0! Using the sample formula 100/0, you can… KB#280094. Keywords: Errors, Formulas, VBA, Macro, Web

   591. How to Change Arabic Page Numbers to Roman Numerals Microsoft Word for Windows has a page numbering option that converts the arabic page numbers to Roman numerals. Microsoft Excel does not have the equivalent built-in functionality; however, this fea ture can be emulated with a Microsoft Visual… KB#139403. Keywords: Printing, VBA, Macro, Setup, Toolbar, Web, ROMAN

   592. Sample Macro to Add or Place Object in Relation to a Range When you add objects to a worksheet using a Microsoft Visual Basic for Applications procedure, you need to specify the coordinates of the new object, in points, relative to the upper-left cor ner of cell A1 on a worksheet as well as the height… KB#213607. Keywords: Outline, VBA, Macro, Object, Web

   593. How to Programmatically Display All Files in a Folder In Microsoft Excel, you can create a sample Microsoft Visual Basic for Applications Sub procedure (macro) that loops through specified files in a folder (directory) and displays each file name in a dialog… KB#213369. Keywords: VBA, Macro, File Name, Files, Web

   594. Pivot Tables Tutorial Using a Pivot Table as Source for Chart If you use a range of data as input to a pivot table — and name that range ” Database”, the Data Form will add new records and include them in the named range. They will be included in th e pivot table (after it is refreshed). You can link a chart to a pivot… Keywords: Charts, AutoFormat, Styles, PivotTables, VBA, Links

   595. Sample Visual Basic Code to Update Links in an Excel Chart This article provides a sample Microsoft Visual Basic for Applications macro (Sub procedure) that updates the links inside a Microsoft Excel Chart object on a Microsoft PowerPoint… KB#25133 7. Keywords: Charts, OLE, Format, Links, VBA, Macro, Object, Web

   596. How to Open a Copy of a Template in Microsoft Excel 2000 Microsoft Excel provides several ways for you to create a copy of a template. However, if you use the Open command on the File menu to open a template, the template opens in edit mode. In versi ons of Microsoft Excel before Excel 97 and Excel 7.0,… KB#213817. Keywords: Startup, VBA, Macro, Templates

   597. How to Turn Off Automatic Font Scaling in All Charts In Microsoft Excel 97, there is a limit of 256 fonts that can be used by the program. Charts that use the automatic scale feature have two fonts instead of one. This article explains how to program matically turn the automatic scale feature off in… KB#292263. Keywords: Charts, Fonts, Errors, VBA, Macro, Error Message, Web

   598. How to Calculate the Number of Days in a Month In Microsoft Excel, you can use date functions to calculate the number of days in a month. For example, you can use the following formula to return the number of days in a month, based on a given startin g date DAY(DATE(YEAR( The_Date… KB#214313. Keywords: Days, Formulas, VBA, Web

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