For business users of Microsoft Excel.
For business users of Microsoft Excel.

 

Home > Excel Help Portal > Programming Excel

<<  (Page 4)  Previous              Next  (Page 6)  >>

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. Using a Visual Basic Macro to Sort Arrays in Microsoft Excel
  2. How to Remove All Items from a ListBox or ComboBox
  3. Macro Doesn't Function on Multiple Sheets in Group Mode
  4. How to Run a Macro When Certain Cells Change
  5. Goto Special Blanks to clean up a pivot table
  6. EnableEvents Property Does Not Work in Automation Server
  7. Fill in the Empty Cells
  8. How to set the Mask Property and the Picture Property for an Office 2003 CommandBar Button
  9. How to Set the Mask and Picture Properties for Office XP CommandBars
  10. Limitations for Naming Visual Basic Modules
  11. How to Remove All Items from a ListBox or ComboBox
  12. How to Prevent the Automatic Creation of Hyperlinks
  13. How to Retrieve a Table from Access into Excel Using DAO
  14. RTD Server Does Not Send Update Notifications to Multiple Excel Instances
  15. Macro to Extract Data from a Chart
  16. How to Display a Progress Bar with a User Form
  17. How to Display Top 10 Records with a Macro
  18. Conditional Formatting to Make Due Dates Stand Out
  19. How to Display Top 10 Records with a Macro
  20. How to Get Prime Numbers or Factors
  21. Function to Convert Degrees/Minutes/Seconds Angles to or from Decimal Angles
  22. Swap as in Swap Columns or Swap Rows
  23. Automation AddIn Function Binds to Excel BuiltIn Function with the Same Name
  24. How to Use the ApplyCustomType Method to Format Charts
  25. Function That Uses the ActiveCell Property Returns Incorrect Result
  26. How to Programmatically Save a Worksheet as HTML
  27. Visual Basic Editor (VBE) Window
  28. Gantt chart on a worksheet
  29. Excel - a VBA function to extract text
  30. Copying Worksheet Programmatically Causes RunTime Error 1004
  31. How to Force Macro Code to Wait for Outside Procedure
  32. How to Send Form Mail That Uses Excel Data
  33. Query to Find Unmatched Records Between Two Files
  34. How to Trap Events for an Embedded Chart
  35. How to Display a Progress Bar with a User Form
  36. How to Assign a Macro to an ActiveX Worksheet Control
  37. How to Assign a Macro to an ActiveX Worksheet Control
  38. How to Set Page Setup Attributes for More Than One Sheet
  39. Properties
  40. How to Add Data to a ComboBox or ListBox in Excel or Word
  41. Solving Common Setup Problems
  42. How to Trap Events for an Embedded Chart
  43. How to Prevent the Automatic Creation of Hyperlinks
  44. Prevent duplicate entries
  45. Macro Examples to Delete Duplicate Items in a List
  46. How to retrieve the Names of Macros from an Excel Workbook by Using Visual Basic 6.0
  47. How To Retrieve a QueryDef from MS Access Using DAO
  48. How to Retrieve Records into Specific Columns Using DAO
  49. Sorting TCP/IP Addresses
  50. How to simulate a PivotTable with No Summarization in Excel 2000

<< (Page 4)  Previous              Next  (Page 6) >>

 Excel User's Home
 ExcelUser Blog      
 Site Map              
 Contact              
 Excel for Business
 Excel Dashboards   
 Excel Solutions   
 Exploring Excel   
 BI for Excel    
 Business Tools   
 Excel Catalog   
 Affiliate Program   
 Excel Help Portal
 
   
     
   
     
 

ExcelUser, Inc.
http://www.ExcelUser.com

Copyright © 2004 - 2009 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.

 


What's your greatest Excel challenge?