Index

Index

Formatting

• Macro to Remove Hyperlinks from Cells
• Extract hyperlink address from shapes
• Macro to trim data
• Macro to clean and trim data
• VBA Code for propercase
• VBA Code for Lowercase
• VBA Code for Uppercase
• Show Busy Mouse cursor while running the Macro
• Format dates like 1st, March 2013 2nd March 2013 etc
• Adding an image as comment( Without VBA)
• Adding an image as comment( With VBA)

Filter

• Macro to remove Auto filter mode
• Unique Values Using Advance Filter
• Applying Like Condition In Advance Filter

Worksheet

• Macro to change Worksheet tab color
• Macro to add new worksheet
• Arrange or sort Worksheet Tabs on Name
• Adding Marquee on Excel Worksheet
• Add a new pop up button on mouse right click menu and assign macro to it
• Display Image on Mouseover
• Create a Quick Custom Format Tab on Mouse Right Click
• Add Worksheet Navigation button on mouse right click
• Add a New menu on Mouse right click for workbook Navigation
• Find The First Cell After Freeze Pane
• Sort data using VBA
• Multiple level sort using VBA
• Sort Data on the basis of Font Color
• Sort Data on the basis of Background Color
• Compare two worksheet ranges from same or different workbook and identify the difference
• Save Specific Worksheet as new workbook
• Display External Links if any in the workbook
• Search a text in excel workbooks and if found return the full path of workbooks
• Print All Formula’s used in a workbook
• Find cells linked to external workbook

File and Folder Name

• Macro to rename file
• Macro to move file from one folder to other
• Get Names of all the files in a folder Excluding Sub folder
• Get Names of all the files in a folder Including Sub folder
• Get Names of all the folders stored in a folder/directory Including Sub folder
• Get Names of all the folders stored in a folder/directory Excluding Sub folder
• Show file name picker dialog box using VBA
• Show folder name picker dialog box using VBA

Notepad

• Macro to Import Data from notepad to Excel 
• Open a delimit notepad file in Excel
• Export Range to Pipe Delimit Text File

Outlook

• Macro to send Chart in Outlook Mail body
• Macro to send Email using Outlook from Excel 
• Send Range as attachment using Outlook and Excel VBA
• Send a Range as formatted table in the outlook email body
• Save Outlook Attachments On Your Desktop
• Import email details from outlook to Excel
• Mark all emails as Read in a Specific Folder in Outlook
• Browse through all emails in Sub Folders of Specific Folder in Outlook and extract the information
• Export or Save Outlook Email as word document using VBA
• Sending Beautiful Birthday Messages to your Staff OR Clients Using Outlook From Excel 
• Loop through all outlook emails saved on your desktop and extract the information

Charts

• Macro to export chart as Image
• Add Chart Title Using VBA
• Remove Chart Borders Using VBA
• Add Chart Borders Using VBA
• Macro to add Axis Titles
• Macro to add gridlines in chart
• Macro to remove gridlines in chart
• Add and Remove fill colors from chart Using VBA
• Add image as background to chart using VBA
• Macro to Replace Markers with Custom shapes On Charts
• Delete all charts on worksheet using VBA
• Set chart axis options using VBA
• Hide and Un-hide Chart Axis using VBA
• Color Chart Series on the Basis of Category Name
• Color Chart Series On The Basis of Values
• Color Chart Series on the Basis of Series Name
• Macro to add Custom DataLabels in Chart
• Hide and Un-hide Data Lables Using VBA
• Hide all data label less than any percentage in Pie Chart Using VBA
• Hide - Unhide Legend Entry Using VBA
• World Map on Excel Using X Y Scatter CHART
• Interactive USA Map & Chart using X Y Scatter chart
• Create In-Cell Charts Using VBA for Data Visualization
• Interactive USA Map Chart using X Y Scatter and Pie Char
• Format X Y Chart using VBA 
• Gantt Chart in Excel 
• Format Line Chart's Markers and Line colors Using VBA 
• Format bubble chart using VBA
• Show Country Flags as Markers on X Y Chart
• Create connections on map using X Y Scatter

UDF

• UDF to Extract Hyperlink Address from Cell
• UDF to extract right most word of a cell
• UDF To return the formula written in a cell
• UDF to check file exits or not
• UDF To return the custom format applied on a cell
• UDF to check folder exists or not
• UDF to find RGB Value of a color
• UDF to extract letters from a cell
• UDF to find redirect Web URL
• UDF to extract Column Name
• UDF to count cells with format Bold or Italics or Strike-through or Underline

Formatting

• Macro to delete shapes on worksheet

Form and ActiveX controls

• Populate form control combo box using VBA
• Populate form control list box using VBA
• Loop through all List-Boxes or Combo-boxes on userform

Arrays

• Store worksheet range in a array
• Save the file names of folder in a dynamic array
• Save Filtered Data in a Array

Export To Powerpoint

• Copy range from Excel and paste as picture in PowerPoint Slide
• Copy Chart from Excel and paste it in PowerPoint Presentation
• Find table names in PowerPoint using VBA
• Group charts in Excel and then paste them on PowerPoint
• Copy a range from excel and paste as table in Powerpoint Slide
• Copy charts in excel and paste it to PowerPoint slide as picture
• Copy all Charts from activesheet and paste them in different slides of PPT
• Copy data from excel to paste in already existing tables of PPT template 

Import  from Powerpoint to Excel

• Copy data from table in PowerPoint to Excel

Import  from Word to Excel

• Search a text in word documents and if found return the full path of document
• Copy word document to Excel
• Copy all tables from a word document and paste them in a separate new workbook
• Copy all tables from a word document to Excel Using VBA
• Copy all tables from word document to separate worksheets

Others

• Create Message box in vba
• Show Progress Bar in Excel While Macro is Running
• Create Sales Funnel Using Shapes In Excel
• Running SQL Queries within Excel Environment
• Copy Data from PDF to Excel Using Send-keys

Google Map API

• Create World Map Using Google Chart and choose your own colors
• Create a country/Region Level Map Using Google Geo charts
• Plot locations on Google Chart map by passing Latitude and Longitude (Country Level)
• Google World Heat Map (By Passing Latitude and Longitude)
• Google Country Level Heat Map (By Passing Latitude and Longitude)
• Google Heat Map charts In Excel (at Country Level)
• Google World Heat Map chart in Excel
• Google Heat Map charts In Excel (at City Level)
• Google World Map chart with markers in Excel
• Google Marker Map charts In Excel (at Country Level)

Internet and Excel 

• Copy Hyperlinks and Text from a webpage to Spreadsheet

Userform

• Move List-box Items up & Down

  

Access 

• Import Data from Access Table 
• Append Data to Access Table from Excel
• Update Access Table from Excel using VBA 
• Type your Sql Query in input box in excel and import data from access to excel

Free Downloads 

• Calender in Excel
  
• Download and Install Free Add-In My Menu Ver 1.6
• Tool to rename multiple files with a single click
• Waterfall Motion Chart 
• Bubble Motion chart
• Mass Email Sending Tool Using Outlook and Excel
• Calender Control on User-form
• India Heat Map on Excel
• Gantt Chart using Stacked bar chart

Note: All Macros are tested and working fine in Excel 2007 Version