Home > Excel Help Portal > Programming Excel

<<  (Page 14)  Previous              Next  (Page 16)  >>

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.

701. Not Enough Memory message Are you creating each chart as its own chart sheet? Excel can handle 16 million cells on a worksheet, but the quiet secret is that is can not handle a lot of worksheets. The help file says that the number of worksheets is limited by "available memory". I regularly experience the problem that you... Keywords: Charts, Errors, Macro, UserForm, VBA, Error Message, Web

 
702. How to Determine Which DLLs Are Registered In Microsoft Excel you can programmatically list the dynamic link library (DLL and XLL) files that provide functions registered in Excel. This article describes a sample macro that creates a three-column array of all registered functions in... KB#213498. Keywords: DLL, Arrays, VBA, Macro, Files, Links, Web

 
703. How to Use the Quit Method to Quit Access from Another Program This article describes how to close Microsoft Access from a different program using Automation and the Quit... KB#210518. Keywords: Microsoft Access, Errors, VBA, Macro, Object, Web

 
704. How to Programmatically Print All Embedded Charts on a Worksheet In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro that prints all embedded charts in an Excel worksheet. Each chart is printed on a separate... KB#213460. Keywords: Charts, Printing, VBA, Macro, Object, Web

 
705. How to Programmatically Insert Blank Rows in a Worksheet In Microsoft Excel 2000, you can use a Microsoft Visual Basic for Applications macro to programmatically insert a blank row between every row of data on your worksheet. The example in this article contains a sample macro that performs this... KB#213318. Keywords: VBA, Macro, Web

 
706. How to open a Document Linked to PasswordProtected Sheet in Excel 2000 This step-by-step article describes how to open a document that is linked to password-protected sheet in Microsoft Excel 2000. If you open a Excel worksheet that is linked to protected worksheets, you are prompted whether to update links to... KB#214314. Keywords: Links, Password, VBA, Macro, Web

 
707. How to Use Data Validation to Prevent Duplicate Entries This article explains how to use data validation to prevent the creation of duplicate entries in a... KB#213185. Keywords: Styles, Errors, Formulas, VBA, Error Message, Validation

 
708. How to Create a Macro That Counts Comments In Microsoft Excel, you can insert notes (comments) 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... KB#213638. Keywords: Printing, VBA, Macro, Web, Comments

 
709. How to Set the Descriptive Name of an Addin File In Microsoft Excel, it is possible to create a descriptive name and descriptive text for an add-in file that is listed in the Add-Ins dialog... KB#120795. Keywords: Add-In, Analysis ToolPak, Query, Links, VBA, Files, Comments

 
710. How to Close All Workbooks but One with Visual Basic Macro This article explains how to create a Microsoft Visual Basic for Applications macro (Sub procedure) that closes all other workbooks when you open a particular... KB#147742. Keywords: Errors, VBA, Macro, Object, Web

 
711. How to Add a Microsoft Excel 5.0 Dialog Sheet to a Workbook This article describes how to add a Microsoft Excel version 5.0 dialog sheet to your... KB#213255. Keywords: ActiveX, VBA, UserForm, Web

 
712. Showing Formulas in Excel Timmy in Orrville asks the first question. I have a very complex worksheet and need to check all of the formulas. Is there any way to have Excel show or print the formulas rather than me having to move the cell pointer to check each formula in the formula bar? #"."000 MrExcel.com provides examples... Keywords: SERIES, Wildcard, Custom Number Formats, Formulas, Printing, Class, VBA, Web, Auditing

 
713. Displays a Tooltip with Duplicate of Number in DDE Link Richard from the Computer America radio show sent in this interesting problem. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a... Keywords: DDE, Third-Party, Format, Formulas, Links, VBA, Web, Column Width, NOW

 
714. Text to Columns using VBA Column A Company Name A PO BOX 1 NEWARK NJ 07101 Company Name B PO BOX 2 1400 SANS SOUCI PARKWAY WILKES-BARRE PA 18703 Company Name C PO BOX 3 CHICAGO IL 60694 Company Name D PO BOX 4 CLEARFIELD UT 84015 Company Name E PO BOX 5 OGDEN UT 84401 Company Name F PO BOX 6 BALTIMORE MD 21264-4351 When I... Keywords: Sorting, Format, Formulas, Macro, VBA, Web, ROW, DSUM

 
715. Dates Inserted by Recorded Macro May Be in Wrong Century In the versions of Microsoft Excel listed at the beginning of this article, if you enter a date in a cell while recording a Microsoft Visual Basic for Applications macro, the macro may enter the wrong date when you run it. Specifically, the date... KB#180159. Keywords: Years, Macro, VBA

 
716. A Visual Basic Nested Case Statement Example In Microsoft Excel 2000, you can use nested case statements in Visual Basic to execute one of several expressions based on a particular value or expression evaluation similar to an IF... KB#213473. Keywords: Dates, VBA, Macro, Web

 
717. Selected Text in Combo Box from Forms Toolbar Overflows into Worksheet Characters that do not fit into the space in a combo box may be displayed to the right of the combo box in the underlying... KB#231088. Keywords: Combo Box, Toolbar

 
718. How to Programmatically Disable Keyboard Functionality In Microsoft Excel, you can programmatically disable all of the keys on the computer keyboard by setting the Microsoft Visual Basic for Applications DataEntryMode property to xlOff . A sample Visual Basic macro that you can use to turn off... KB#213509. Keywords: VBA, Macro, Web

 
719. How to Check Spelling for Worksheet Objects Only In Microsoft Excel, you can check spelling for just the objects on a worksheet. You can do this manually or with Microsoft Visual Basic for Applications... KB#142531. Keywords: AutoShapes, VBA, Macro, Object, Web

 
720. How to Select the Current Region Minus the First Row This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that selects the current data area without the top... KB#148462. Keywords: AutoFilter, VBA, Macro, Web

 
721. Excel Pivot Table Date Order MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Dates, Months, Sales, PivotTables, VBA, Web

 
722. Use a number format to make zeroes not appear The real problem is that if you enter this simple formula in Excel, =Z1 and cell Z1 is empty, the answer to that formula is 0 instead of a blank. This can be horribly frustrating.There is no perfect solution to this problem, but here are two ideas:1. Make the original cells with no data contain a... Keywords: Custom Number Formats, Formulas, Links, VBA, Web

 
723. Advanced Pivot Table Operations You probably know how to create a basic pivot table. Here are some obscure pivot table tricks which will help you get the most out of pivot tables. Pivot Table Wizard The Basics: At right, you can see the familiar old basic default pivot table. Regions and products are sorted alphabetically, totals... Keywords: Dates, Sales, PivotTables, VBA, Web

 
724. Data Validation dropdowns disappear after freeze panes Caroline from the U.K. came up with this problem. I have a forecasting worksheet that has been in use for several weeks without a problem. The worksheet has Data Validations with dropdown boxes in columns C & D. I changed some fonts and repositioned the frozen window so that the user can see... Keywords: Forecasting, Fonts, Errors, VBA, Error Message, Web, Validation, Window

 
725. Macro High Security Warning or User Defined Functions Display #Name? When you start Microsoft Excel or open a workbook, you may receive the following or similar error message: Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe.... KB#277608. Keywords: Errors, Macro, VBA

 
726. Running a Microsoft Project Macro from Microsoft Excel This article contains an example to demonstrate how Microsoft Excel can run a Microsoft Project macro using DDE (dynamic data exchange) and Visual Basic for Applications... KB#133710. Keywords: DDE, VBA, Macro, Files, Web

 
727. How to Import an Entire Worksheet from an Excel Workbook This article shows you how to use Visual Basic for Applications to import an entire worksheet from a Microsoft Excel workbook without specifying a... KB#210379. Keywords: Microsoft Access, Errors, VBA, Web

 
728. How to Create a Masked Password Dialog Box in Visual Basic for Applications In Microsoft Excel, you can create a custom dialog box to prompt a user for information by using text boxes, buttons, or other dialog box controls. Typically, when you type text in a text box, the text appears as you type. However, you can use... KB#830258. Keywords: Text Box, Password, Command Button, VBA, Object

 
729. Links to Frequently Asked Questions Keywords: Errors, Links, Class, VBA, AutoSave, Hyperlinks, Web, Comments

 
730. How to Determine How Many Pages Will Be Printed Microsoft Visual Basic for Applications does not provide a method to determine the total number of pages that will print in a worksheet. However, you can use the ExecuteExcel4Macro method to use the GET.DOCUMENT(50) macro sheet function to return... KB#139405. Keywords: Printing, VBA, Macro, Web

 
731. How to Check Spelling for Worksheet Objects Only In Microsoft Excel, you can check spelling for just the objects on a worksheet. You can do this manually or with Microsoft Visual Basic for Applications... KB#213608. Keywords: AutoShapes, VBA, Macro, Object, Web

 
732. Macro to conditional highlight cells Ed asked this week's question. I need a simple macro that will search lets say..column C and highlight red the cells that contain todays date (current date) and highlight yellow any other cell in the column that is 15 days in the future from todays date? Users of Excel 97 or Excel 2000 can take... Keywords: Criteria, Days, Conditional Formating, Formulas, Macro, VBA, Web, TODAY

 
733. InputBox and MsgBox Keywords: Arrays, Errors, Formulas, VBA, Object, Web, Comments

 
734. How to Create and Use a Workbook_BeforeClose Procedure You can run a Microsoft Visual Basic for Applications macro ( Sub procedure) every time a particular workbook is closed, by attaching the procedure to the BeforeClose event of the workbook. This article contains sample code that illustrates how to... KB#213639. Keywords: Format, VBA, Macro, Object, Web

 
735. How to Close All Workbooks But One with a Visual Basic Macro This article explains how to create a Microsoft Visual Basic for Applications macro (Sub procedure) that closes all other workbooks when you open a particular... KB#213806. Keywords: Errors, VBA, Macro, Object, Web

 
736. How to Create Excel Chart w/OLE Automation from Visual Basic This article illustrates how you can use Automation in a Visual Basic program to create an Excel workbook that contains a chart embedded on a... KB#142387. Keywords: Charts, SERIES, Command Button, VBA, Object

 
737. How to Continue a Visual Basic Statement from One Line to the Next To make Microsoft Visual Basic for Applications procedures easier to read, you may want to continue a line of code from one line to the next. To write code in this way, use the line-continuation... KB#213640. Keywords: VBA, Web

 
738. Incorrect Attachment Name/Icon For Word/Excel Attachments In the Adding Attachments to a Message topic under Programming Tasks in the CDO (1.2x) help file, it is stated that for CdoFileData and CdoOle type of attachments, ReadFromFile method and for CdoFileLink type of attachments, Source method of... KB#198897. Keywords: Errors, VBA, Object

 
739. How to make Paste Options Disappear After You Paste in Excel 2002 After you perform a copy and paste operation in Microsoft Excel, the Paste Options are displayed near the paste destination. This step-by-step article explains how to make the Paste Options disappear or prevent them from appearing. Make Paste... KB#289577. Keywords: Clipboard

 
740. Formatting Time Values Since then, traffic has picked up tremendously. I am about to hit my one-millionth page view for the year 2001. There is enough consulting work to keep myself busy, plus more projects for Juan Pablo and Mala and occassionally Access projects for Mike and data analysis for John. People are simply... Keywords: Days, Years, Format, Sounds, Macro, VBA, Web

 
741. Updating old information The professor walked up to the board, wrote the familiar equation that was the basis for Newtonian physics, "F=ma". This stands for Force = Mass x Acceleration. Then, he dropped a bomb shell. "Everything that we have taught you over the last 3 semesters is wrong. F does not equal ma." He went on to... Keywords: Years, VBA, Web

 
742. How to Create a Macro That Opens Multiple Selected Files In the Open dialog box in Microsoft Excel, you can select more than one file to open at a time. If you are using Microsoft Visual Basic for Applications with the GetOpenFileName method, you must use a macro to loop through the selected files to... KB#141574. Keywords: Arrays, Macro, VBA, File Name, Files, Web

 
743. Automatically get the date and time Since most of the MrExcel readers read the page at work, I'll start with an introduction here. I was reading the local newspaper and they had an article about the trendy, new, easy-to-use Weblog technology. Basically, it is easy to create a daily posting to your web site, without having to go... Keywords: Days, VBA, Web, NOW, TODAY

 
744. How to Open a Document Linked to PasswordProtected Sheet When you open a Microsoft Excel worksheet that is linked to protected worksheets, a dialog box will appear asking whether to update links to unopened worksheets. If you click Yes, another dialog box will appear asking for the passwords of the... KB#63091. Keywords: Links, Password, VBA, Web

 
745. Books about Excel I have included a selection of books which have mostly been awarded five stars by readers who have purchased them. If you follow these links to Amazon, they are sold with a discount of 15%-30% A great reference for the beginner and the pressed-for-time, this book is organized as a series of... Keywords: Charts, SERIES, Dates, Format, Formulas, Links, VBA, CD-ROM

 
746. "The Macros in This Project Are Disabled" Error Running Macro When you run a macro in the Samples.xls file, you receive the following error message: The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable... KB#215715. Keywords: Errors, Macro, VBA, Setup, Setup Program

 
747. An Excel VBA macro and button to select another workbook This page illustrates a simple macro that can be placed in your Personal.xls workbook and is then available to switch between all open workbooks in turn. This is an alternative to selecting the Window menu option (or using a keyboard shortcut) and then choosing the required workbook. Excel allows... Keywords: Formulas, VBA, Macro, Toolbar, Window, MATCH

 
748. How to Delete and Restore a Menu That Has a Submenu In a Visual Basic for Applications macro, if you delete a menu item that has a submenu and you want to restore it, use the Addmenu command, not the Add command. Addmenu adds a new menu (or submenu), while Add adds a new menu... KB#125423. Keywords: VBA, Web

 
749. How to Determine How Many Pages Will Be Printed Microsoft Visual Basic for Applications does not provide a method to determine the total number of pages that will print in a worksheet. However, you can use the ExecuteExcel4Macro method to use the GET.DOCUMENT(50) macro sheet function to return... KB#213810. Keywords: Printing, VBA, Macro, Web

 
750. Excel Displays Only First Column in Embedded Worksheet Microsoft Excel displays only the first column in an Auto-Formatted multiple-column worksheet object embedded from a file. This problem occurs when the instance of Microsoft Excel that is opened is subsequently closed. This behavior is exhibited... KB#129793. Keywords: OLE, Object, VBA

 

<< (Page 14)  Previous              Next  (Page 16) >>