Microsoft Excel Macros Tutorials
  Microsoft Excel Macros Tutorials
2D Graphics
3D Graphics
Web Design & Development
Business Applications
Business Development
Databases
Desktop Programming
Operating Systems
Video Editing
Miscellaneous
Newsletter
User Login
  • Username
  • Password
Stats
  • Tutorials: 38,026
  • Categories: 572
  MS Excel Tutorials : Macros TutorialsRSS Subscribe to this feed using your favorite reader
Microsoft Excel is an application that helps you create intricate and dynamic spreadsheets. Use this robust application to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

  • No sub-categories
 
JOIN OUR MS EXCEL DISCUSSION FORUM
 
Total:

56 MS Excel Macros Tutorials

Displaying: 11 - 20
Prevent Case Sensitivity in VBA Code
in MS Excel / Macros
2010-07-13
Prevent Case Sensitivity in VBA Code MS Excel tutorial
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This mean
Rating: Tutorial Rating 2.78Tutorial Rating 2.78Tutorial Rating 2.78Tutorial Rating 2.78Tutorial Rating 2.78
Hits: 6082
Comments: 0
Votes: 309
Broken Link?
Display AutoFilter Criteria
in MS Excel / Macros
2010-07-13
Display AutoFilter Criteria MS Excel tutorial
Use a custom function to display the criteria used for any column in a table with an AutoFilter appl
Rating: Tutorial Rating 2.59Tutorial Rating 2.59Tutorial Rating 2.59Tutorial Rating 2.59Tutorial Rating 2.59
Hits: 8777
Comments: 0
Votes: 215
Broken Link?
Force Text to Upper- or Proper Case
in MS Excel / Macros
2010-07-13
Force Text to Upper- or Proper Case MS Excel tutorial
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only.
Rating: Tutorial Rating 2.89Tutorial Rating 2.89Tutorial Rating 2.89Tutorial Rating 2.89Tutorial Rating 2.89
Hits: 5267
Comments: 0
Votes: 204
Broken Link?
Change Text to Upper- or Proper Case
in MS Excel / Macros
2010-07-13
Change Text to Upper- or Proper Case MS Excel tutorial
When using a built-in Excel function is impractical, you can use a custom macro to change any existi
Rating: Tutorial Rating 2.64Tutorial Rating 2.64Tutorial Rating 2.64Tutorial Rating 2.64Tutorial Rating 2.64
Hits: 4591
Comments: 0
Votes: 133
Broken Link?
Hide and Restore Toolbars in Excel
in MS Excel / Macros
2010-07-12
Hide and Restore Toolbars in Excel MS Excel tutorial
Attach a custom toolbar to your spreadsheet that doesn't get in the way of the end user's settings f
Rating: Tutorial Rating 2.61Tutorial Rating 2.61Tutorial Rating 2.61Tutorial Rating 2.61Tutorial Rating 2.61
Hits: 3272
Comments: 0
Votes: 170
Broken Link?
Track and Report Changes in Excel
in MS Excel / Macros
2010-07-12
Track and Report Changes in Excel MS Excel tutorial
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA an
Rating: Tutorial Rating 2.59Tutorial Rating 2.59Tutorial Rating 2.59Tutorial Rating 2.59Tutorial Rating 2.59
Hits: 5076
Comments: 0
Votes: 194
Broken Link?
Excel Three-Criteria Limit for Conditional Formatting
in MS Excel / Macros
2010-07-10
Excel Three-Criteria Limit for Conditional Formatting MS Excel tutorial
You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In
Rating: Tutorial Rating 2.64Tutorial Rating 2.64Tutorial Rating 2.64Tutorial Rating 2.64Tutorial Rating 2.64
Hits: 5005
Comments: 0
Votes: 224
Broken Link?
Retrieve a Workbook Name and Path
in MS Excel / Macros
2010-07-10
Retrieve a Workbook Name and Path MS Excel tutorial
Every now and then you might want a cell to return the name of a workbook, or even the workbook's fi
Rating: Tutorial Rating 2.81Tutorial Rating 2.81Tutorial Rating 2.81Tutorial Rating 2.81Tutorial Rating 2.81
Hits: 2828
Comments: 0
Votes: 170
Broken Link?
Run Procedures on Protected Worksheets
in MS Excel / Macros
2010-07-10
Run Procedures on Protected Worksheets MS Excel tutorial
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might t
Rating: Tutorial Rating 2.71Tutorial Rating 2.71Tutorial Rating 2.71Tutorial Rating 2.71Tutorial Rating 2.71
Hits: 2763
Comments: 0
Votes: 177
Broken Link?
Distribute Macros
in MS Excel / Macros
2010-07-10
Distribute Macros MS Excel tutorial
Although you can distribute a macro along with a workbook, if you want to distribute only the macro'
Rating: Tutorial Rating 2.72Tutorial Rating 2.72Tutorial Rating 2.72Tutorial Rating 2.72Tutorial Rating 2.72
Hits: 3333
Comments: 0
Votes: 169
Broken Link?




Developer Shed Affiliates

 



© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap