UDF to Fetch Comment Text in Excel Cell
In this article, you will learn how to create a UDF to Fetch Comment Text in Excel Cell VBA to get the comment text from an Excel Cell. Let’s say we
Tag: 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 VBA User form which can segregate your data into worksheets. One user from will
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
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
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
Protect Excel Worksheet as UserInterFaceOnly
Just assume you a worksheet wherein you have few groups for column or rows and then you Protect Excel Worksheet that worksheet. Now will you be able to expand or
Fully Functional Dynamic Calendar Control in VBA
Ah, The complexities of automation! The versatile and multifaceted world of Excel VBA offers an array of tools and functionalities to streamline tasks and make life easier. Yet, despite its
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
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
Data Consolidation: Allow User to select files on Runtime
In this article, we will explain to you the Data Consolidation from multiple Excel files using Application.GetOpenFileName in VBA. You can easily allow the user to select multiple excel files