Saturday, January 28, 2012

My Menu ver 1.0 - Change Case

1 Change Case -



a) Proper Case - It will change the selected cells to proper case.

b) Lower Case - It will change the selected cells to Lower case.

C) Upper Case - It will change the selected cells to Upper case.

D) Sentence Case - It will change the selected cells to Sentence case.


Note : To use simply select the cells first and then run the macro from drop down. snapshot below


at
Labels:

1 comment:

  1. Excel VBA CodebaseJanuary 28, 2012 at 9:11 PM

    Download Link http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html

    ReplyDelete

Subscribe to: Post Comments (Atom)

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...

  • Export Range in Json Format
    Macro to Export Range in Json Format Option Explicit Sub export_in_json_format()     Dim fs As Object     Dim jsonfile     Dim rangetoex...
  • Running SQL Queries within Excel Environment
    If you want to run SQL queries within Excel environment without  connecting to any database, you can do it with creating the ADODB   conn...