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
Tag: VBA
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
Resize and Relocate the Chart using Excel Range
In this article you will learn a trick to resize and relocate a chart using VBA. We have created a shortcut key Shift+Ctrl+R to resize and relocate active chart. You
VBA.Inputbox Vs Application.Inputbox in Excel VBA
In this article you will learn the use of VBA.Inputbox Vs Application.Inputbox in VBA. Input box is used to take the input from use on run time. VBA.Inputbox Vs Application
Create Multiple Folders from Excel Range
In the previous article you have learnt how to check the whether a folder exist or not. In this article you will learn we can create multiple folders on one
Check Folder Existence using VBA
During the automating some task in VBA, many times we need to check that a folder is exits or not. For example if you want to create or delete a