Home > Excel Help Portal > Programming Excel

<<  (Page 11)  Previous              Next  (Page 13)  >>

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.

551. How to Open a Copy of a Template in MS Excel 7.0, 97 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 earlier versions of Microsoft Excel, when you click Open on... KB#133137. Keywords: Startup, VBA, Macro, Templates

 
552. Visual Basic Equivalents for Lotus Macro Commands (WE1277) Microsoft offers an Application Note titled Visual Basic for Applications Equivalents for Lotus 1-2-3 Macro Commands (WE1277). This Application Note contains equivalent macro code in Visual Basic for Applications for most Lotus 1-2-3... KB#148240. Keywords: Download, Macro, VBA, Files, TEXT

 
553. How to Create and Use an Auto_Close Procedure An Auto_Close procedure is an automatic procedure stored in a workbook that runs automatically when the workbook is closed. You can place automatic procedures in any Microsoft Visual Basic for Applications module in the workbook. A... KB#141563. Keywords: VBA, Macro, Web

 
554. How to Convert an Addin File into a Workbook In Microsoft Excel 97, you can convert an add-in (.xla) file into a normal workbook (.xls) file that you can view and edit. This article contains detailed information about converting an add-in... KB#156943. Keywords: Add-In, Charts, Password, VBA, File Name, Files, Window

 
555. How to Programmatically Copy All Range Names In Microsoft Excel, you can create a Microsoft Visual Basic for Applications Sub procedure (macro) that you can use to copy all the range names from the active workbook to another... KB#213389. Keywords: Defined Name, VBA, Macro, File Name, Web

 
556. Excel: an advanced filter to extract records If you have a list of records contained in a range of cells it is possible to extract all records that meet a specified set of criterion and place them elsewhere in your workbook. For example in a list of names and personal details you could find everyone who works for a particular organisation and... Keywords: Advanced Filter, Criteria, Query, Format, VBA, Macro, DSUM

 
557. Macro to Delete Every Other Row This article contains a sample Microsoft Visual Basic for Applications macro that you can use to delete every other row in a selected range on a Microsoft Excel... KB#213610. Keywords: VBA, Macro, Web

 
558. How to Show Quotation Marks in Function Results and Macros When you type directly in a cell, you can type quotation marks and they appear in the cell both on the screen and when you print them. However, if you use the CONCATENATE() function or the concatenation operator (&), the quotation marks must... KB#141578. Keywords: Formulas, Printing, Macro, VBA, Web, CONCATENATE

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

 
560. Benefits of On Line Consulting Read Microsoft Solution Study about development work performed by John F. Lacher CPA for D-Tools. The D-Tools development included components built with Visual Basic 6, Active Server Pages, Jet Databases, Visio, Excel, Access, Word and Project. Custom Application Development Via the Internet -... Keywords: Charts, Years, OLE, Formulas, PivotTables, Printing, Macro, VBA, Files, Text Files

 
561. ACC: How to Use the Quit Macro Action or Quit Method This article demonstrates two methods that you can use to close Microsoft Access from a different application. The first method uses the Quit macro action to quit Microsoft Access over a dynamic data exchange (DDE) channel. The second method... KB#100149. Keywords: DDE, Microsoft Access, OLE, Errors, VBA, Macro, Object

 
562. Sample Visual Basic Code to Create Color Index Table The sample macro in the More Information section of this article prints a sample of each color in one column, and then prints the index number for that color in the adjacent column. This type of list is valuable for determining how a certain... KB#213801. Keywords: Colors, ColorIndex, Format, Patterns, Errors, Printing, VBA, Macro, Web

 
563. Sample Macros to Return ID for a CommandBar Control The ID property for the CommandBar object uses a unique number for each built-in menu bar, shortcut menu bar, submenu, menu item, or toolbar. The ID is often required when you reference a control on a command bar. The Visual Basic for... KB#213211. Keywords: Charts, Formulas, PivotTables, VBA, Macro, Object, Menu Command, Toolbar, Web

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

 
565. How to Export a Graph from Access to Excel You can use Microsoft Graph to embed a graph object in a Microsoft Access form or report. However, if you export the form or report to an Excel worksheet, the graph does not appear in the worksheet. This article describes how to export a... KB#208327. Keywords: Query, Export, Microsoft Access, Object

 
566. How to Programmatically Delete and Restore a Menu That Contains a Submenu This article describes how to programamtically delete and restore a menu that contains a submenu. If you use a Microsoft Visual Basic for Applications macro to delete a menu item that contains a submenu, and then you want to restore the menu item,... KB#213437. Keywords: VBA, Macro, Menu Command, Web

 
567. How To Create a Dynamic Chart Using Visual Basic When you record a macro to create a chart, the source address of the cells you used to create the chart are fixed by Microsoft Excel. This article contains a Visual Basic for Applications macro that you can use to create a chart when the... KB#157940. Keywords: Charts, VBA, Macro, Object, Toolbar, Web

 
568. How to Call a Macro Repeatedly on a Fixed Time Interval You can call a macro repeatedly at a set time interval using the OnTime method and the Call... KB#151503. Keywords: Format, VBA, Macro, Toolbar, Web

 
569. How to Hide Button Controls with Visual Basic for Applications This article describes how to prevent buttons, such as command and option button controls, from being printed in the following situations. If the buttons are the only objects on the worksheet. If the worksheet that you want to print contains... KB#213832. Keywords: Graphic, Format, Printing, VBA, Macro, Object, Web

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

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

 
572. How to Create Yes and No Buttons for a Custom Message Box By default, the MsgBox function in a Microsoft Visual Basic for Applications procedure contains a single OK button. However, you can display other buttons in the message box. This article provides a sample Visual Basic macro that displays a... KB#213613. Keywords: VBA, Macro, Toolbar, Web

 
573. Changing an Integer to an Excel Serial Number Many programs export dates as integers. This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that transforms an integer date into a Microsoft Excel serial... KB#213446. Keywords: Dates, Export, Format, VBA, Macro, Web

 
574. Printing using macros Expanding the possibilites with Macros This page contains some VBA macros. If you need assistance to install or to use a macro please refer refer to my GetFormula... Keywords: Errors, Formulas, Printing, VBA, Macro, Setup, Web, Comments, Window

 
575. Automation Example with Microsoft Word and Microsoft Outlook It is possible to create a Visual Basic for Applications macro that uses data from a Microsoft Word document and a Microsoft Excel workbook to send messages from Microsoft Outlook. This article contains an example of one way that you can do... KB#213712. Keywords: VBA, Macro, Object, Web

 
576. How to Play Sounds Using Visual Basic for Applications In Microsoft Excel 97, cell notes have been replaced with cell comments and no longer support sound notes. However, you can use a Visual Basic for Applications procedure to play sounds. In order to play a sound in a Visual Basic for... KB#158140. Keywords: API, Sounds, VBA, Macro, Web, Comments

 
577. How to Hide Sheets and Use xlVeryHidden Constant in a Macro In Microsoft Excel, you can hide sheets in a workbook so that a user cannot see them. You can hide any type of sheet in a workbook, but you must always leave at least one sheet... KB#213609. Keywords: Format, VBA, Macro, Object, Web

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

 
579. How to Delete a Collection of Code Objects from a VBAProject This article contains a sample Microsoft Visual Basic for Applications macro to loop through all the objects in a VBProject , and remove the objects contained in a specific collection. For example, you can remove all standard module sheets in... KB#260993. Keywords: Class, VBA, Macro, Object, VBE, Web

 
580. Programatically find a blank row NYARCH writes: I want to have excel copy an entire row to a new sheet based upon a cell entry. For example I have data in cells A8:AG8, I want to have Excel copy the entire row to sheet "a" if the value in H8 is "ir", and sheet "b" if the value in H8 is "RR" and not just copied, I need it copied to... Keywords: AutoFilter, Days, VBA, Macro, Web

 
581. WordCount Keywords: VBA, Object, Web, Comments, TRIM

 
582. Sample Macro to Determine If a Year Is a Leap Year In Microsoft Excel, you can determine whether a date occurs during a leap year by using a Microsoft Visual Basic for Applications... KB#266672. Keywords: VBA, Macro, Web, Window

 
583. How to Make Spinner Whose Minimum Value Is Less Than Zero In the products listed at the beginning of this article, the spinner control that is on the Forms toolbar has a minimum value of zero. This article includes a Microsoft Excel Visual Basic for Applications macro example that demonstrates how you... KB#151324. Keywords: Format, VBA, Macro, Object, Toolbar, Web

 
584. Link back to original workbook There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in... Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

 
585. Selecting files within VBA There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in... Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

 
586. Stopping an Endless Loop There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in... Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

 
587. How to Change Connection Information for a Query After you change the folder location or server name of a database that a query or PivotTable is using in Microsoft Excel, you cannot manually change the connection information to the new folder or server. This article offers a programmatic... KB#816562. Keywords: Query, Arrays, PivotTables, VBA, Macro, Web

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

 
589. How to Remove UserDefined Functions from Function Wizard When you create a custom function in Microsoft Excel using Visual Basic for Applications, it will be displayed in the Function Wizard under the User Defined Function category. You can prevent the custom function from being displayed in the... KB#142123. Keywords: VBA, Macro, User Defined Function, Web

 
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: #DIV/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 feature 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 corner 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 the 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#251337. 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 versions 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 programmatically 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 starting 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

 
600. How to Play Sounds Using Visual Basic for Applications In Microsoft Excel 2000, cell notes have been replaced with cell comments and sound notes are no longer supported. However, you can use a Microsoft Visual Basic for Applications procedure to play sounds. To play a sound in a Visual Basic... KB#213777. Keywords: API, Sounds, VBA, Macro, Web, Comments

 

<< (Page 11)  Previous              Next  (Page 13) >>