Name Manager
Uncategorized VBA

Create Multiple Names using VBA in Excel

Our daily Excel activities can be automated using VBA. Here we have created an example of creating the Name range in Excel using VBA. Lets’ say we have below given data for which we have create the Names- [caption id="attachment_15185" align="aligncenter" width="1131"] Data to create the Names[/caption] We have created a button on the Home tab and assigned the macro on this button. [caption id="attachment_15183" align="aligncenter" width="559"] Additional button added
Get Comments UDF
VBA

UDF to Fetch Comment Text in Excel Cell

In this article, you will learn how to create a User-defined function in VBA to get the comment text from an Excel Cell. Let’s say we have attendance data on the Excel sheet and We are putting comments for the absent employees. Now if we need to fetch these comments in Excel cell to do some analysis then we can use this UDF. [caption id="attachment_14475" align="aligncenter" width="699"] Get Comments UDF[/caption]
Segregate data into Worksheets
VBA

VBA User form for Segregate data into multiple worksheets

Many times, we require to segregate our data into different worksheets. Here we have created a macro which can segregate your data into worksheets. One user from will be displayed wherein you can select the field name by which you want to segregate your data. Below is the data which we will segregate into multiple worksheets- [caption id="attachment_14190" align="aligncenter" width="495"] Data[/caption] We have added an icon on home tab to
Shell Function in VBA
VBA

Shell Function in VBA with Example

Shell function in VBA is very useful. If you want to start a program or open a executable file then you can use shell function in VBA . In this article we will explain shell command for below 3 examples- Start a Program Open a Folder Open a Non-Excel file Below is the syntax of Shell function- Shell (pathname, windowstyle) Pathname: The full path of the program to execute (String).
VBA Login Form
VBA

Login Form for Excel VBA based Application

Login Form is very important for any application. We have designed this Login form in VBA User form and connected with MS Access Database. We have used ADODB Connection to connect with MS Access Database. To create the design of this Login form we have taken the support of Microsoft Power Point also. Click here to learn more about ADODB Connection. Below is the snapshot of MS Access database table
PDF to Word Converter
VBA

PDF to Word Converter Macro in Excel VBA

In this article we will tell how you can develop your own PDF to Word converter using Excel VBA. You can convert multiple files using this macro. Keep all your PDF files in one folder. You need to provide the link of PDF and word files folder path on Excel Sheet (Rename is as Settings). Word files folder should be empty. Word files will be saved into this folder after
VBA Shortcut Keys
VBA

33 Useful VBA Shortcut Keys

Keyboard Shortcut Keys can improve your productivity. In this article we will tell you 33 useful VBA shortcut keys. If you are a VBA developer or work on VBA frequently then these shortcut keys are very useful to you. You can quickly design your User form using these shortcut keys. Below is the list of 33 useful VBA Shortcut Keys- [table id=9 /]   Click here to download this practice
User Interface Protection
VBA

Protect Excel Worksheet as UserInterFaceOnly

Just assume you a worksheet wherein you have few groups for column or rows and then you protected that worksheet. Now will you be able to expand or collapse those groups? No, you cannot expand or collapse it because it will show error as worksheet is protected. [caption id="attachment_13217" align="aligncenter" width="1166"] How to expand or collapse group while worksheet is protected[/caption]   If your worksheet is protected and you want
Evaluate Formula
VBA

UDF for Evaluate a Formula in Excel

In this article you will learn how to create a User Defined Function to evaluate a formula in Excel. You will also learn how to get text of formula using a User Defined Function and FORMULATEXT (Excel 2013 and above). Below is the code to create the User Defined Function to evaluate a formula in Excel Function Evaluate_Formula(formula_text As String) As Variant      Application.Volatile     Evaluate_Formula = Application.Evaluate(VBA.Trim(formula_text))
Merge Same Cells
VBA

VBA: Quickly merge cells with same value in Excel

In this article you will learn how to quickly merge same cells in Excel using VBA. Using this VBA code, you can merge multiple columns data together. This trick can save a lot of time. Just select the range for which you want to merge the cells with same values and run this macro. You can copy this code to the personal macro so that it will available for every