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,024
  • 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: 6064
Comments: 0
Votes: 308
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: 8760
Comments: 0
Votes: 214
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.90Tutorial Rating 2.90Tutorial Rating 2.90Tutorial Rating 2.90Tutorial Rating 2.90
Hits: 5242
Comments: 0
Votes: 203
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.63Tutorial Rating 2.63Tutorial Rating 2.63Tutorial Rating 2.63Tutorial Rating 2.63
Hits: 4568
Comments: 0
Votes: 132
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: 3250
Comments: 0
Votes: 169
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: 5054
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.65Tutorial Rating 2.65Tutorial Rating 2.65Tutorial Rating 2.65Tutorial Rating 2.65
Hits: 4988
Comments: 0
Votes: 223
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: 2813
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.70Tutorial Rating 2.70Tutorial Rating 2.70Tutorial Rating 2.70Tutorial Rating 2.70
Hits: 2740
Comments: 0
Votes: 176
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: 3319
Comments: 0
Votes: 169
Broken Link?




Developer Shed Affiliates

 



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