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,004
  • 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.75Tutorial Rating 2.75Tutorial Rating 2.75Tutorial Rating 2.75Tutorial Rating 2.75
Hits: 6258
Comments: 0
Votes: 331
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.53Tutorial Rating 2.53Tutorial Rating 2.53Tutorial Rating 2.53Tutorial Rating 2.53
Hits: 8950
Comments: 0
Votes: 283
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: 5437
Comments: 0
Votes: 215
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.66Tutorial Rating 2.66Tutorial Rating 2.66Tutorial Rating 2.66Tutorial Rating 2.66
Hits: 4813
Comments: 0
Votes: 141
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.67Tutorial Rating 2.67Tutorial Rating 2.67Tutorial Rating 2.67Tutorial Rating 2.67
Hits: 3431
Comments: 0
Votes: 184
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.61Tutorial Rating 2.61Tutorial Rating 2.61Tutorial Rating 2.61Tutorial Rating 2.61
Hits: 5241
Comments: 0
Votes: 200
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.62Tutorial Rating 2.62Tutorial Rating 2.62Tutorial Rating 2.62Tutorial Rating 2.62
Hits: 5142
Comments: 0
Votes: 246
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.84Tutorial Rating 2.84Tutorial Rating 2.84Tutorial Rating 2.84Tutorial Rating 2.84
Hits: 2978
Comments: 0
Votes: 190
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.73Tutorial Rating 2.73Tutorial Rating 2.73Tutorial Rating 2.73Tutorial Rating 2.73
Hits: 2964
Comments: 0
Votes: 195
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: 3459
Comments: 0
Votes: 179
Broken Link?




Developer Shed Affiliates

 



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