Hierarchy Chart :


Hi All, I have customize stack bar chart to a hierarchy chart by using some VBA, This chart displays the next level data of a selected , user can select a parameter by double click on a series, Example : you can download  .xlsm from here Note : You can use it with excel 2010….

Encrypt and Decrypt Text


Here is a basic Function to Encrypt and Decrypt  any text Public Function evtEncrypt_Decrypt(strText As String, strPWD As String) As String     Dim byteText() As Byte     Dim bytePWD() As Byte     Dim intPWDPos As Integer     Dim intPWDLen As Integer     Dim intLoop As Integer     byteText = strText…

Comment Formatting


This code can be use to Format a Comment , you can make your excel cell comment bit beautiful by using below  code   Sub FormatComment()       Dim rngRange As Range     Dim rngCell As Range     Dim objCom As Comment          Set rngRange= Range(“rngRange”)     For…