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: 6260
Comments: 0
Votes: 332
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: 5442
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: 4816
Comments: 0
Votes: 142
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.68Tutorial Rating 2.68Tutorial Rating 2.68Tutorial Rating 2.68Tutorial Rating 2.68
Hits: 3436
Comments: 0
Votes: 185
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.62Tutorial Rating 2.62Tutorial Rating 2.62Tutorial Rating 2.62Tutorial Rating 2.62
Hits: 5243
Comments: 0
Votes: 205
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: 5143
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: 2981
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: 2967
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: 3465
Comments: 0
Votes: 179
Broken Link?




Developer Shed Affiliates

 



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