Home > Excel Help Portal > Programming Excel

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

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.

601. How to Determine Whether VBA Is Enabled for Office XP Application This article explains how to determine whether Microsoft Visual Basic for Applications (VBA) is installed and enabled for Microsoft Office... KB#285884. Keywords: API, VBA, Object, Registry

 
602. How to Programmatically Change the Project Name Property By default, when you open a new workbook in Microsoft Excel 97, the Name property for the workbook project is VBAProject (without the quotation marks). This naming convention may cause a problem if you manually or programmatically attempt to... KB#161214. Keywords: Errors, VBA, Macro, Object, VBE, Web, Window

 
603. How to Make Sure That Your Office Document Has a Valid Digital Signature This article describes how to: Make sure that a digitally signed Microsoft Office document has a valid digital signature. Make sure that a document was not tampered with after the document was originally digitally... KB#329228. Keywords: VBA, Web, IS

 
604. How to Use Application.Match to Locate Date Values on a Worksheet In Microsoft Excel, you may run into problems if you use the Match method in a Microsoft Visual Basic for Applications macro or procedure to locate date values on a worksheet. When you use a macro to search for dates, you need to search for the... KB#213643. Keywords: Dates, Errors, VBA, Macro, Web

 
605. How to convert Excel column numbers into alphabetical characters This article discusses how to convert integers into alphabetical... KB#833402. Keywords: VBA, Web

 
606. How to Programmatically Save a File to a Network Drive In Microsoft Excel, you can save a file to any drive to which you have write and delete privileges. In addition, you can use a Microsoft Visual Basic for Applications macro to save the active workbook and use a variable for the file name. You can... KB#141512. Keywords: VBA, Macro, File Name, Save A File, Web

 
607. How to Programmatically Hide and Unhide the Windows Taskbar By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95/98 or Microsoft Windows NT 4.0 taskbar. This article shows you how to create the two functions that you need to hide and unhide the... KB#202099. Keywords: API, VBA, Web

 
608. How to Use Visual Basic to Create a Dynamic Chart When you record a macro to create a chart, the source address of the cells that you use 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#213780. Keywords: Charts, VBA, Macro, Object, Web

 
609. How to Remove the Control Menu and Program Window Controls In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro to remove or disable the program window and worksheet... KB#213456. Keywords: Errors, VBA, Macro, Web, Window

 
610. Macro to Link a Range of Cells in Word This article provides an example of how to link a Microsoft Excel worksheet to a Microsoft Word document using a Microsoft Visual Basic for Applications macro in conjunction with OLE Automation... KB#213316. Keywords: OLE, VBA, Macro, Object, Links, Web

 
611. Embedded Excel Worksheets Shrink When You Edit Them In Microsoft PowerPoint, when you edit an embedded Microsoft Excel worksheet, the worksheet object resizes... KB#300523. Keywords: Object, Registry

 
612. Data Validation The answer to this problem is using Data Validation. This feature, introduced in Excel 97 offers a simple way to have a drop down list right in the cell. There is no problem with moving or resizing.This is a great feature to know. I am embarrassed that after 50+ tips of the week, I have never fully... Keywords: ActiveX, Errors, Links, Defined Name, VBA, Web, Validation, Window

 
613. How to Create a Macro That Counts Text Notes (Cell Notes) In Microsoft Excel, you can use a text note 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 Visual Basic... KB#141564. Keywords: Printing, VBA, Macro, Web, Comments

 
614. Preventing UserForm from Being Dismissed with Close Button When you create a UserForm , a Close button is added to the upper-right corner of the UserForm window. To prevent a user from closing the UserForm with the Close button, use the QueryClose event of the UserForm... KB#213713. Keywords: Command Button, VBA, UserForm, Web, Window

 
615. Calculating Depreciation with the Production Method Microsoft Excel includes functions to calculate straight line (SLN), sum of the years digits (SYD), and double-declining balance (DDB) depreciation. A fourth depreciation method, the production method, is widely used in business to... KB#213497. Keywords: Years, Formulas, VBA, Macro, Web

 
616. How to Populate One List Box Based on Another List Box This article contains an example of using the selected item in one list box control on a UserForm to determine the list that will populate a second list box... KB#213748. Keywords: VBA, UserForm, Web, Window

 
617. Excel -- Data Entry -- Convert Text to Numbers Convert Text to Numbers Convert with Paste Special Convert Dates with Replace All Convert with Text to Columns Convert Trailing Minus Signs Convert Trailing Minus Signs Programmatically Paste as CSV Convert Programmatically If you copy data from another program, such as Microsoft Access, or from a... Keywords: Dates, Errors, VBA, Macro, Toolbar

 
618. How to Automatically Set Min and Max Scale for YAxis In Microsoft Excel, you can set the Minimum and Maximum properties of the y-axis scale to any value. The example in this article shows the steps necessary to create a Microsoft Visual Basic for Applications procedure that determines the minimum... KB#213644. Keywords: Charts, SERIES, Arrays, VBA, Macro, Web

 
619. Macro to Restore Tab Split Box to Default Position In Microsoft Excel 2000, 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#213505. Keywords: VBA, Macro, Web, Window

 
620. How to Programmatically Save a File to a Network Drive In Microsoft Excel, you can save a file to any drive to which you have write and delete privileges. In addition, you can use a Microsoft Visual Basic for Applications macro to save the active workbook and use a variable for the file name. You can... KB#213641. Keywords: VBA, Macro, File Name, Save A File, Web

 
621. How to Hide and 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 remove a menu and then... KB#213708. Keywords: VBA, Macro, Object, Web

 
622. Rounding numbers If I enter a formula to take one-third of a number like 100,000 - how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don't want the decimals to enter into subsequent calculations?Surround the formula with... Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

 
623. Getting Rid of Broken Links If I enter a formula to take one-third of a number like 100,000 - how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don't want the decimals to enter into subsequent calculations?Surround the formula with... Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

 
624. Getting Rid of Broken Links If I enter a formula to take one-third of a number like 100,000 - how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don't want the decimals to enter into subsequent calculations?Surround the formula with... Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

 
625. How to Control the Placement of Objects In Microsoft Excel 97, you can control how charts, drawing objects, AutoShapes, controls, and other objects contained in a worksheet are attached to the cells below them. This article explains how to set the Placement property for objects in... KB#168651. Keywords: Charts, AutoShapes, Format, Styles, Errors, Class, Macro, Object, VBA, Window

 
626. How to Populate One ListBox Based On Another ListBox This article contains an example of using the selected item in one ListBox control on a UserForm to determine the list that will populate a second ListBox... KB#161518. Keywords: VBA, UserForm, Web, Window

 
627. How to Display a ComboBox List When a 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#213718. Keywords: VBA, UserForm, Web, Window

 
628. How to Automate Inserting an Excel Chart into Word This article includes a sample Microsoft Visual Basic for Applications macro that inserts an existing Microsoft Excel chart into a new Word... KB#212514. Keywords: Charts, VBA, Macro, Object, File Name, Web

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

 
630. How to a Make Spinner with a Minimum Value Less Than Zero In Microsoft Excel, the spinner control that is on the Forms toolbar has a minimum value of zero. The Microsoft Excel Visual Basic for Applications macro example in this article demonstrates how you can use a spinner control that appears to... KB#213303. Keywords: Format, VBA, Macro, Toolbar, Web

 
631. How to Make a Macro That Automatically Starts When You Open a Workbook One way to automatically run a macro when you open a workbook is to use the Workbook_Open event in Microsoft Excel. Workbook_Open is a built-in workbook event that runs its macro code each time you manually open the workbook. The following... KB#265113. Keywords: VBA, Macro, Object, Web, Window

 
632. Excel Filters -- AutoFilter Programming AutoFilter Programming A few examples of controlling AutoFilters through VBA programming. Show All Records Turn On AutoFilter Turn Off AutoFilter Hide Filter Arrows Copy Filtered Rows AutoFilter on a Protected Worksheet Count Visible Rows AutoFilter Basics Show All Records The following code shows... Keywords: AutoFilter, Errors, VBA, Macro

 
633. Unsigned Macros May Be Trusted When Macro Security Setting Is High When you start Microsoft Excel, Excel opens an unsigned workbook that contains Microsoft Visual Basic for Applications macros, and enables the macros in the workbook, even though you have set the macro security level to... KB#235069. Keywords: Errors, Startup, Macro, VBA, Templates

 
634. How to Determine If a Variable Is an Array You can use the IsArray function to test a variable that has been set in a Microsoft Visual Basic for Applications procedure to determine whether it is an... KB#151561. Keywords: Arrays, VBA, Macro, Web

 
635. How to Save Personal Macro Workbook When Excel Is Open When you make changes to your Personal Macro Workbook and then hide it again, you normally have to quit Microsoft Excel to save the changes you made. The sample Microsoft Visual Basic for Applications macro in the More Information section of... KB#141576. Keywords: Startup, VBA, Macro, Web

 
636. How to Control the Placement of Objects In Microsoft Excel 2000, you can control how charts, drawing objects, AutoShapes, controls, and other objects contained in a worksheet are attached to the cells below them. This article explains how to set the Placement property for objects in... KB#211835. Keywords: Charts, AutoShapes, Format, Styles, Errors, Class, Macro, Object, VBA, Window

 
637. Sample Macro That Won't Allow User to Cancel Dialog Box In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro to display built-in dialog boxes, such as the Open or the Save As dialog box. After this type of dialog box is displayed, a user can cancel it by clicking Cancel... KB#213617. Keywords: VBA, Macro, Web

 
638. How To Share a Custom AutoFill List In Microsoft Excel 2000, custom lists are stored in the Microsoft Windows registry. You can exchange custom lists from one computer to another by using a macro that creates the custom list from a spreadsheet. The More Information section of... KB#213796. Keywords: VBA, Macro, Registry, Toolbar, Web

 
639. How to Simulate Combination ListEdit Control for UserForms When you use a UserForm in Microsoft Excel 2000, there is no control that is equivalent to the combination list-edit control for custom dialog boxes in versions of Excel before Excel 97. You can simulate the behavior of a combination list-edit box... KB#211896. Keywords: Text Box, VBA, UserForm, Web, Window

 
640. Write an ICS We have a sacred duty in our department; probably in yours. Somebody has to bring donuts to staff meeting on Friday. I was determined to find a way to generate Calendar Files that I could send to the interested party each week. In the end, I created a monster (that I will share with you. The... Keywords: Days, Holidays, Formulas, Links, Printing, VBA, Macro, Files, Web

 
641. How to Call a Macro Repeatedly on a Fixed Time Interval In Microsoft Excel, you can call a macro repeatedly at a set time interval using the OnTime method and the Call... KB#213288. Keywords: Format, VBA, Macro, Web

 
642. How to Create Functions to Calculate Light Years Microsoft Excel does not include a function that will convert miles into light years or light years to miles. However, you can use the following formulas for this calculation Miles to Light Years M / 5,877,000,000,000 Light Years to Miles LY... KB#142152. Keywords: Years, Format, Formulas, VBA, Web

 
643. 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#213633. Keywords: Formulas, Printing, Macro, VBA, Web, CONCATENATE

 
644. How to Add a New Category to Function Category List To manually create a custom category for a user-defined function that you write in Microsoft Visual Basic for Applications, you must insert a Microsoft Excel 4.0 macro sheet before you create the... KB#137526. Keywords: Macro, Object, VBA

 
645. How to Manually Recalculate a Single Cell or Range In Microsoft Excel 2000, the Calculate Now command (on the Tools menu, click Options , and then click the Calculation tab) causes every cell in the open worksheet to be recalculated, even when the calculation mode is set to Manual . This... KB#213490. Keywords: Arrays, Formulas, VBA, Web

 
646. How to Programmatically Make Sure That Only Numbers Are Entered in a Column This article contains a sample Microsoft Visual Basic for Applications Sub procedure (macro) that you can use to ensure that only a certain type of data entry occurs. The macro in this article requires a user to enter only numbers in a specific... KB#213358. Keywords: VBA, Macro, Web, Validation

 
647. Cell Related Coding last cell even with empty cells in the column you could use Range("A65535").End(xlUp).select 'Example only Range("A" & Rows.Count).End(xlUp).Select Cells(Rows.Count,1).End(xlUp).Select Range(ActiveCell, ActiveCell.End(xldown)).Select xldown xlup xltoRight xltoLeft The use of 65536 to identify the... Keywords: Arrays, Formulas, VBA, Toolbar, Web, Comments, MAX

 
648. Print Help File for Excel 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: Printing, VBA, Files, HTML, Hyperlinks, Web, Window

 
649. How to use a Macro to Enter Cell Note Text in a Text Box This article describes how to put the text of a cell's comment (cell note) into a text box. A macro that does this may be especially helpful because you do not have the ability to manually copy text from the comment dialog box and paste it into a... KB#213623. Keywords: Text Box, VBA, Macro, Web, Cell Note

 
650. 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#141513. Keywords: VBA, Web

 

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