Home > Excel Help Portal > Programming Excel

<<  (Page 20)  Previous              Next  (Page 1)  >>

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.

1001. Force Uppercase Entry Example Visual Basic for Applications procedure converts lowercase text entered in a column to uppercase. You can use an OnEntry procedure to run a Visual Basic for Applications procedure each time that data is entered into the worksheet. The procedure can convert lowercase text to uppercase is the... Keywords: Download, Format, OnEntry, VBA

 
1002. Pad Number of Digits Keywords: Formulas, Links, VBA

 
1003. Displaying Sequence of Colors or the portion of another picture that overlays the cell. Guide to the Example: A VBA macro is called from the Display Colors in Cell button. It displays the colors that overlay the cells A1 to A14. Download an Example File in Excel 5 format: Lacher42.XLS (104KB) - about two minutes to download... Keywords: Download, Colors, Format, Macro, VBA

 
1004. Chart Controlled With Button Example of control buttons on a chart used to change the 3D view and trend line settings. You can use a very simple Visual Basic for Applications procedure to call any one of Excel's hundreds of built in dialogs. This example shows the Dialogs method used to call the 3d view and trend line dialogs.... Keywords: Charts, Trend line, Download, Format, VBA

 
1005. Count Numeric Values Function Public X As Long, Y As Long, D As Long, G As Variant 'User-defined function to count numeric values in a string... Keywords: Formulas, Links, VBA

 
1006. Compare 2 Lists A new twist came recently with: {=SUM(IF($A7=Details!$B$2:$B$622,IF(Details!$D$2:$D$622=Sheet1!$H$1,1,0)))} Remember, to tell Excel that you are making an array, hold Ctrl+Shift while pressing Enter. The new one looks at a city in A7 and if it is in B2 thru B622 of the Details sheet; then compare... Keywords: Arrays, Formulas, Links, VBA

 
1007. Write Error to Log Remember to do an "Exit Sub inside your code before the Error Handler so that the Handler is not invoked each time your macro runs. Exit Sub ErrHandler: Open "ErrorLog.log" For Append As #2 'Open file Print #2, Application.Text(Now(), "mm/dd/yyyy HH:mm") _ ; Error(Err); Err 'Write data Close #2... Keywords: Errors, Formulas, Links, Printing, VBA, Macro

 
1008. Hierarchical Listbox The class ajpHList allows you to use a normal userfrom Listbox in a similar way to a Treeview list....Where Nodes (listitems) are stored within other Nodes. Appropriate Nodes can be opened to reveal related nodes or closed to conceal them. Opening and closing of Nodes can be done either with double... Keywords: Fonts, Links, Class, UserForm, VBA

 
1009. Pie chart single image When using a picture as the fill effect on a normal pie chart each pie segment contains a copy of the image. One way around this is to use the fill effect for the plot area. This works well for images based on round objects, but it can leave parts of the image sticking out of the... Keywords: Charts, Plot, Links, Object, VBA

 
1010. Easter Function Can't remember where I got it, but here is the Function for figuring Easter. To get Good Friday for my list since it is a company holiday, I use... Keywords: Formulas, Links, VBA

 
1011. Delete Duplicates Here is a quicky to spin down through a list and remove the duplicates. Be sure you list is sorted before beginning. Public CurRow, oZ, uY,... Keywords: Criteria, VBA

 
1012. Making a worksheet very hidden You can use Excel's Format, Sheet, Hide to hide an entire worksheet. But unless you password-protect the workbook structure, anyone can select Format, Sheet, Unhide to see the hidden sheet. If you use Excel 97 or later, here's another option: To unhide the sheet, repeat these step, but set the... Keywords: Charts, Format, Formulas, Printing, VBA

 
1013. eBay Commissions The Final Value Fee is calculated per item sold, based on the final sale price of the item. I wrote the formula for one person, verify with eBay befopre accepting as exact.... Keywords: Formulas, Links, VBA

 
1014. OverPunch Code Keywords: Formulas, Links, VBA

 
1015. Inserting Automatic Page Breaks You can use the subtotal feature to add a page break after each change in a sort key. For example, your can subtotal on vendor as shown in the figure below and Excel will add a page break for each vendor value. Use menu option Data, Subtotals and choose the Page Break Between Groups option. ; You... Keywords: Sorting, Arrays, VBA

 
1016. VBA Macros - Custom Excel VBA Macros from Mr Excel Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of the Tickling Keys, Inc. All contents Copyright 1998-2003 by MrExcel... Keywords: Macro, VBA, CD-ROM

 
1017. Coloured dropdown control The download contains a demonstration and overview of a class that will generate a coloured dropdown list on a userform. All the code is available for... Keywords: Download, Links, Class, UserForm, VBA

 
1018. Excel FAQ Answers to Frequently Asked Questions about Microsoft Excel Collected by Harald Staff, Microsoft Excel MVP Table of Contents The Excel Application and Excel Files Worksheet Functions and Formats Dates and Times Macros, VBA Functions I didn't find my answer here, now what? Good Resources on the Web... Keywords: Dates, VBA, Files, Web

 
1019. Header This chart shows the intersection points of 2 lines. The Intersections series is the result of a user defined function. The download illustrates the use of the functions and the layout of the series... Keywords: Charts, SERIES, Download, Links, User Defined Function, VBA

 
1020. What's this help? The download contains a demonstration of how to mimic What's This Help. I have written a class to handle the help and help text. All the code is available for... Keywords: Download, Links, Class, VBA

 
1021. Dynamic and Interactive Charts Keywords: Charts, Months, Links, Combo Box, VBA

 

<< (Page 20)  Previous              Next  (Page 1) >>