Home > Excel Help Portal > Programming Excel

<<  (Page 21)  Previous              Next  (Page 2)  >>

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.

1. Build Table of Contents, similar listings, working with Hyperlinks
2. Rearranging Data in Columns
3. Date & Time
4. Shortcut Keys in Excel 2000 (Excel Version 9)
5. How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel
6. Slow Response, Memory Problems, and Speeding up Excel
7. Event Macros, Worksheet Events and Workbook Events
8. Onsite pages and related off-site material for Excel pages
9. Show FORMULA or FORMAT of another cell
10. Backup your files, always take backups
11. Color Palette and the 56 Excel ColorIndex Colors
12. Toolbars, Custom Buttons and Menus
13. Fill-Handle, Replication and use of the Mouse
14. Mail Merge, Printing Labels using Mail Merge with data from Excel
15. Worksheets in VBA Coding and in Worksheet Formulas
16. How to customize menus and menu bars in Excel
17. Excel to HTML conversions
18. Delete Cells/Rows in Range, based on empty cells, or cells with specific values
19. Shortcut Keys in XL95 (Excel Version 7)
20. How to transfer Data to an Excel Workbook by Using Visual Basic .NET
21. Strings and Manipulations
22. Considerations for ServerSide Automation of Office
23. How to use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
24. Install Macros and User Defined Functions
25. How to Minimize Metadata in Microsoft Excel Workbooks
26. Lastcell, Reset Last Used Cell
27. How to create an Office XP Smart Tag DLL by Using Visual Basic .NET
28. How to troubleshoot errors when you save Excel files
29. Macro Examples Using XLODBC Functions
30. Methods for Transferring Data to Excel from Visual Basic
31. How to Create MS Access Database from MS Excel Using DAO
32. How to create a Smart Tag DLL in Visual Basic for Use in Office XP
33. How to Use "On Error" to Handle Errors in a Macro
34. How to Use "On Error" to Handle Errors in a Macro
35. How to Embed and Automate Office Documents with Visual Basic
36. How to Select Cells/Ranges Using Visual Basic Procedures in Excel
37. WorksheetProtection Options Overview
38. How to Dismiss a Dialog Box Displayed by an Office Application with Visual Basic
39. Overview of Visual Basic Editor Debugging Tools
40. How to transform a DataSet to spreadsheet XML for Excel by using Visual Basic .NET and ASP.NET
41. Contextures Excel Book List
42. Getting Started with Macros and User Defined Functions
43. Overview of Excel 2002 Update: June 19, 2002
44. How to build an Office COM Addin by Using Visual Basic .NET
45. You receive runtime error 429 when you automate Office applications
46. How to Determine If Your Workbook Contains Links to External Data
47. How to dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET
48. FloatingPoint Arithmetic May Give Inaccurate Results
49. XL2GIF and Manipulations
50. Issues that are fixed in Excel 2002 by Office XP Service Pack 3

<< (Page 21)  Previous              Next  (Page 2) >>