Home > Excel Help Portal > Programming Excel

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

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.

451. How to Programmatically Turn Off the Clipboard Warning Message When you close a Microsoft Excel workbook, there is no setting to prevent you from receiving a warning message that prompts you to save or delete information from the Clipboard. This article explains why this warning message occurs and how to... KB#287392. Keywords: Borders, Clipboard, Macro, Object, VBA, Web

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

 
453. How to Suppress "Save Changes?" Prompt 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#213428. Keywords: VBA, Macro, Web

 
454. How to Run a WordBasic Macro from a Microsoft Excel Macro In Microsoft Excel 2000, you can programmatically create a Visual Basic for Applications macro that uses either Dynamic Data Exchange (DDE) or Automation with Microsoft Word 2000 to run a WordBasic macro. This article demonstrates these methods... KB#213430. Keywords: DDE, Printing, VBA, Macro, Object, Web

 
455. Visual Basic Macros That Add or Remove Hidden Apostrophes You can use a Microsoft Visual Basic for Applications macro to change a formula or a value to text and vice-versa. To change a formula or value to text, run a macro that adds a hidden leading apostrophe in front of the formula or value. To restore... KB#213440. Keywords: Format, Formulas, Printing, VBA, Macro, Web

 
456. How to Change the Paper Source Using the SendKeys Command It is possible to change the default paper source used by printer drivers in Microsoft Windows Windows 95 and later versions of Windows by using the SendKeys command within a Visual Basic for Applications subroutine in Microsoft Excel 2000. NOTE :... KB#213815. Keywords: Page Setup, Macro, VBA, Web

 
457. Grayed Out Options CommandBars("AutoCalculate").Reset Make sure you are not in Edit mode by hitting Exc (Escape key), as edit mode will gray out a lot of menu options -- notably most Edit options (except cut & paste). Will grayout Options under Toolbar; many options under Data and under Window. Probably have sheet... Keywords: Colors, Formulas, Page Setup, Printing, VBA, Macro, Files, Toolbar, Web, Comments, Window

 
458. How to Use Automation to Fill a List Box This article shows you how to use Automation to populate a list box with values from a Microsoft Excel worksheet. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using... KB#210145. Keywords: Microsoft Access, OLE, Combo Box, VBA, Object

 
459. How to export an XML Spreadsheet File into Generic XML in Excel 2002 This step-by-step article describes how you can create a generic Extensible Markup Language (XML) file from an XML Spreadsheet file by using an Extensible Stylesheet Language (XSL) template. How to Add a Reference to the Microsoft XML Version... KB#295005. Keywords: Export, XML, Styles, VBA, Macro, Object, Templates, Web

 
460. Use group in Pivot Tables to add Years Steve, a client from the Carolinas, asked the question which lead to this tip. It is common for data imported from an external system to have a date field. There is a simple method with in a pivot table to have the date field converted to weeks, months, quarters or years. MrExcel.com provides... Keywords: Dates, Days, Months, Years, PivotTables, VBA, Web

 
461. How to Change the ToolTip for a Custom Toolbar Control Microsoft Office programs do not allow you to change the ToolTip for a custom toolbar control by using the Customize command (on the Tools menu). To change the ToolTip, you must use a Microsoft Visual Basic for Applications macro. This... KB#171595. Keywords: VBA, Macro, Toolbar, Web

 
462. How to Remove Leading Space for Values Converted to Strings The Microsoft Visual Basic for Applications Str() function returns the string representation of a numeric value represented as (n). Positive numbers and zeros are converted to a string with a leading space character. This article discusses... KB#290359. Keywords: Sales, Macro, VBA, Web

 
463. Visual Basic Macro to Change Between Relative and Absolute References In Microsoft Excel, you can use the ConvertFormula method in a Microsoft Visual Basic for Applications procedure to convert cell references from A1 reference style to R1C1 reference style. This method also allows you to change from an absolute to... KB#213465. Keywords: Styles, Errors, Formulas, VBA, Macro, Error Message, Web

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

 
465. Populate Dialog This example shows the scoring dialog that the assistant is presented after transferring all the answers. While preparing this example, I saw a few things I plan to repair the next time I can go into the code. This was written for Excel 7.0/95 and works well in Excel... Keywords: Formulas, Links, VBA

 
466. How to create Functions to Calculate Light Years in Excel 2000 This step-by-step article shows you how to create functions in Excel 2000 to calculate light years. Microsoft Excel does not include a function that converts miles into light years or light years into miles. This article explains how to create... KB#214260. Keywords: Years, Format, Formulas, VBA, Web

 
467. How to Move Between Custom UserForms with Command Buttons When you create a project with multiple UserForms, you can use command buttons to move between the UserForms. This article explains how to create two UserForms and includes a sample Visual Basic for Applications macro that moves between the... KB#213747. Keywords: Text Box, Command Button, VBA, Macro, UserForm, Web

 
468. ShowDataForm Method Fails If Data Can't Be Found In Microsoft Excel, when you use the Visual Basic ShowDataForm method, you may receive the following error message: Run-time error '1004': ShowDataForm method of Worksheet class... KB#110462. Keywords: Errors, Defined Name, Class, VBA, Web

 
469. How To Share a Custom AutoFill List In Microsoft Excel, custom AutoFill lists are stored in the Microsoft Excel toolbar file. You can exchange custom lists from one computer to another either by copying the Microsoft Excel toolbar file or by using a macro that creates the custom... KB#150360. Keywords: VBA, Macro, Toolbar, Web

 
470. Enumerate Addins The following table was created using a macro at http://www.herber.de/mailing/020598v.txt showing how simple a conversion from Excel to HTML can be (safe and simple). Actually after an HTML editor reprocesses the HTML code, the code is no longer as simple. The macro which generated the Excel... Keywords: Add-In, Analysis ToolPak, Solver, Query, Fonts, Arrays, Links, VBA, Macro, AutoSave, Templates, HTML, Window

 
471. DAO Error After Installing Visual Basic DAO Application Microsoft Excel 97 may return the following error message when using DAO 3.5, if an application created with Visual Basic 5.0 that uses DAO is installed. Run-time error '429': ActiveX component can't create... KB#189607. Keywords: ActiveX, DAO, Errors, VBA, Error Message, Registry, Window

 
472. How to Use DAO to Create a New Microsoft Excel Workbook In Microsoft Excel, you can use the Data Access Object (DAO) library in a Visual Basic for Applications macro to work with an external database. You can create a new Microsoft Excel workbook with DAO using the instructions included in this... KB#139402. Keywords: DAO, Defined Name, VBA, Macro, Object, Web

 
473. Excel Stops After Specifying Conditional Format When you specify a conditional format that refers to a user-defined function, the Microsoft Excel screen may stop updating or may be redrawn incorrectly, or Microsoft Excel may stop... KB#156892. Keywords: Colors, Conditional Formating, VBA, Web

 
474. How to Add Data to a DropDown or List Box In Microsoft Excel, there are two ways of populating a list or drop-down box: you can link worksheet data to the control, or you can run a Microsoft Visual Basic for Applications macro to add data to the... KB#141573. Keywords: Format, Arrays, Formulas, VBA, Macro, Object, Links, Web

 
475. How to Implement Application.AutomationSecurity In Office 2000, automation is considered a trusted state, and, therefore, macros in a file are turned on by default, regardless of the security setting. Application.AutomationSecurity allows Office XP programs to support security for solutions... KB#317405. Keywords: Errors, VBA, Macro, Object, Files

 
476. How to Control the AutoFilter with a Macro In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. This article contains several sample Microsoft Visual Basic for Applications macros (Sub procedures) for controlling the AutoFilter feature in... KB#141770. Keywords: AutoFilter, Criteria, VBA, Macro, Web

 
477. Visual Basic Procedure to Change the Standard Font This article includes a sample Microsoft Visual Basic for Applications procedure that you can use to change the standard font in Microsoft Excel. This procedure may be useful if you are creating a custom program and you want to be able... KB#213469. Keywords: Fonts, Format, Styles, VBA, Macro, Web, Window

 
478. Exporting Excel Data in Special Formats You can use a VBA procedure to export data in comma delimited format. Or, change the delimiting character to export the data separated by semicolons,... Keywords: Export, Format, Styles, Errors, Printing, VBA, Iteration, Macro, Menu Command, Text Files

 
479. Macro to Change File Type to "All Files (*.*)" in Open Dialog Box In the Open dialog box in Microsoft Excel, the default setting in the Files of type box is Microsoft Excel Files (*.xl*; *.xls; *.xla; *.xlt; *.xlm; *.htm; *.html). This article provides a sample Visual Basic for Applications macro that changes... KB#213755. Keywords: VBA, Macro, Files, Toolbar, Web

 
480. Visual Basic Function to Format Complex Numbers Because Microsoft Excel stores complex numbers as text, complex numbers cannot be formatted like real numbers. This article provides sample code for a user-defined function that applies number formats to complex... KB#213294. Keywords: Format, VBA, Web

 
481. How to Use the DataEntryMode Property This article contains information about using the DataEntryMode property in Microsoft Excel and includes a sample Microsoft Visual Basic for Applications... KB#162715. Keywords: VBA, Macro, Web

 
482. How to Copy the Text Within a Text Box to a Cell This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that copies the text within a text box and pastes it into a spreadsheet. After following the steps outlined in this article, you should see the text appear... KB#152379. Keywords: Text Box, VBA, Macro, Toolbar, Web

 
483. How to Display the Open and Save As Dialog Boxes This article describes how to programmatically display the Open or the Save As dialog boxes in Microsoft Excel. Note that the Open and Close methods do not display these dialog... KB#213371. Keywords: VBA, Macro, File Name, Web

 
484. Unlocked Cells Not Underlined with Protection Enabled In Microsoft Excel versions earlier than 5.0, while worksheet protection is enabled and gridlines are turned off, unlocked cells appear underlined. This underline identifies the cells that you can edit. Although this feature is not available... KB#213661. Keywords: Borders, Format, Gridlines, Password, Macro, VBA, Web

 
485. Simulating the Lotus pipe feature to suppress row printing 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: Years, Formulas, Printing, VBA, Macro, Web, Window

 
486. Macro to Restore Tab Split Box to Default Position In Microsoft Excel, it is possible to adjust the space allocated for displaying sheet tabs and the horizontal scroll bar by moving the tab split box. The tab split box is located between the sheet tabs and the horizontal scroll bar. This... KB#106009. Keywords: VBA, Macro, Web, Window

 
487. How to Return the Nth Word from a String This article contains a sample Microsoft Visual Basic for Applications function that extracts a particular word from a... KB#152568. Keywords: Formulas, VBA, Toolbar, Web

 
488. How to import Data from Microsoft SQL Server into Microsoft Excel This step-by-step guide describes how to import data into Microsoft Excel from the Pubs database, a sample database that is included with Microsoft SQL Server. ActiveX Data Objects (ADO) provide access to any type of data source. It is a flat... KB#306125. Keywords: Query, ActiveX, Import Data, OLE, SQL, Errors, Object, VBA, Web, DB

 
489. How to Programmatically Modify Hyperlink Addresses on a Worksheet This article demonstrates how to use Microsoft Visual Basic for Applications (VBA) to update or replace hyperlinks throughout a workbook or on only a single... KB#247507. Keywords: Links, VBA, Macro, Object, Hyperlinks, Web, Window

 
490. SumIf with 2 conditions Bill send in this week's question. I have a database of events and my boss wants me to plot frequency charts by month. I read your trick to change daily dates to monthly dates and about CSE formulas. I have tried every criteria I can think of in the CountIf formula below to get it to look at 2... Keywords: Charts, Plot, Criteria, Dates, Arrays, Formulas, PivotTables, VBA, Web, COUNTIF

 
491. How to Turn off Shortcut Menus Delete Rename Move or Copy...... KB#213757. Keywords: Charts, Plot, SERIES, AutoShapes, Query, ActiveX, OLE, Formulas, PivotTables, VBA, Macro, Object, Web

 
492. How to Prevent Customization of Menus and Toolbars In Microsoft Office 97, Service Release 1 (SR-1), the CommandBars object model allows you to turn off (disable) the Toolbars shortcut menu. This simplifies preventing others from changing the toolbars and menus of a custom application that you... KB#170563. Keywords: VBA, Object, Menu Command, Toolbar, Web

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

 
494. Macro That Changes Cell Dimensions on Multiple Sheets Doesn't Run As Expected If you record a macro that changes column widths, changes row heights, or hides and unhides rows or columns while multiple sheets are selected, the macro may not run as expected. In such a case, when you run the macro, only the active sheet in... KB#213823. Keywords: Format, Arrays, VBA, Macro, Web, Window

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

 
496. Excel Code Examples - Personalized Greeting I had gotten in the habit of sending my friends an email with the words “Happy Birthday” dancing down the page. Each time I copied from the original, I would add a new twist. But alas, something was missing. It was too much trouble to personalize it. I could not add a friends name without resorting... Keywords: SERIES, Printing, VBA, Macro, Text Files, Links

 
497. How to create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000 The step-by-step article shows you how to use an Auto_Open macro to select a specific sheet in a workbook and automatically display the data form dialog box. NOTE : A macro named auto_open will be run each time you manually open the workbook... KB#213624. Keywords: Criteria, VBA, Macro, Web

 
498. Populate a Dialog Box We have this test for new people in my office. While I do not have control of what is on the test, I wrote and re-wrote (ad infinium) the spreadsheet for scoring. Basically, a candidate takes the test and the office assistant who is usually not technical and does not know or care about the answers;... Keywords: VBA

 
499. How to Programmatically Select Every Nth Row in a Range In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro to select every nth row in a currently selected contiguous range on a worksheet. This article describes a sample macro that performs this... KB#213438. Keywords: VBA, Macro, Web

 
500. Macro to Change the Date/Time Format in a Header/Footer In Microsoft Excel, when you use the date code, &[Date], to insert the date in the header or footer of a document, the date appears in the default MM/DD/YY format. The time code, &[Time], appears in the default H:MM AM/PM format. These date... KB#213742. Keywords: Custom Number Formats, Printing, VBA, Macro, Setup, Web

 

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