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

 

Home > Excel Help Portal > Programming Excel

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

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. Add a percentage to all cells in a range
  2. Highlight Exception Values
  3. Animated Line Chart
  4. Click on Chart to Select a New Source Range
  5. Change recorded macro to import text file in next available row instead of using A1 every day.
  6. Use Edit / Replace to Remove Decimal Points
  7. Trapping Errors
  8. Advanced VBA Tutorial
  9. Custom Dialog and List Box
  10. Using a List Box to Change Data Displayed in a Workbook
  11. List Box Lookup
  12. Change Case to Mixed
  13. Recorded Macro to a Usable Macro
  14. Pop Up List box
  15. Increment a Counter everytime a Userform is opened
  16. Use Index and Match to lookup a cell to the left of your key cell
  17. Macros - Custom Excel Macros in VBA from Mr Excel
  18. Comparison of Three Sort Methods
  19. Custom Dialog Example
  20. Rounding time to a specific value
  21. Add a Single Quote
  22. How to filter out duplicate data
  23. Working with time formats
  24. Counting Cells with specific content
  25. Maximized view on open
  26. Number of Days, Months and Years Between Two Dates
  27. Parsing with characters
  28. Change Case
  29. MrExcel's Recommendations: Access help
  30. Input Validation
  31. Inserting an image into a worksheet footer
  32. Creating multiple lines of text in a messagebox
  33. Programming a messagebox for user responses
  34. Changing a cell's background color
  35. Add Data to Next Row
  36. Maximum Sustainable Growth
  37. Delete a worksheet in a macro without having to see the "This worksheet will be permanently deleted"
  38. Bypass Delete Confirmation
  39. Data Validation
  40. Change a Cell Value without Changing the Formula
  41. Convert 11.5 to 11 minutes and 30 seconds
  42. Rounding Numbers
  43. Switching between active worksheets
  44. Run a Macro Automatically When the Workbook Opens
  45. Custom Document Properties
  46. GANTT Chart for Scheduling Resources
  47. Entering Time Without the Colon
  48. Mail from Excel
  49. Count Numeric Values in String
  50. Macro to Save File as name in A1

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

 Home              
 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 - 2008 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?