Word Cloud is also known as text cloud or tag cloud. Size of the words change according to the value or weightage or frequency of any word. Here we have created a macro to create the word cloud in Excel. In this macro file, we have 2 worksheets Setting Worksheet – In this worksheet, you need to enter your data, like we have entered the Country wise population. We have
In this article, you will learn how to create a PDF to Excel converter using Excel VBA. We have created a Setting worksheet wherein we are taking 2 folders inputs on range E11 and E12 respectively. PDF Files Folder: Wherein all the PDF files are available Excel File Folder: Wherein Excel files will be saved after conversion. [caption id="attachment_15980" align="aligncenter" width="658"] Setting Sheet[/caption] Add the Microsoft Scripting Runtime Reference
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
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]
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 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).
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
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
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
This Fully Functional Dynamic Calendar Control in VBA, we have designed to use in VBA project. You can use it for Excel Cells, Textbox, Label and Command Button etc. It is very easy to call this Calendar for your VBA Project. You can call this with two method. Just move this calendar form in your VBA project just drag it using mouse [caption id="attachment_12621" align="aligncenter" width="542"] Move Calendar to your
