When you have large amount of data in multiple sheets and you want to get the search results dynamically as you type , you can add a user form in excel vba and create a search box as below. Display search result in listbox from all sheets as you type To create this search box, … Read more
In VBA we can assign the color property of the object by changing or assigning the color index. There are 56 color index which you can use in vba. Below are the list of color indexes you can use in vba. Below is the VBA code to list out the color and color codes in … Read more
When you move your mouse pointer over a ribbon command, you will see a pop-up box that contains the command’s name, as well as a brief description. For the most part, the commands in the Ribbon work just as you would expect them to. Below are the different style of commands on the Ribbon: Simple buttons Click the … Read more
How to write Macro to create bulk pdf in Excel ? Excel vba pdf : Excel VBA programming is a powerful tool to automate the task. We can automate the repetitive task and save lot of time in work. Mastering excel vba will definitly help us in improving the work efficiency. In this post you can … Read more
Excel is a spread sheet software developed by Microsoft, used for numerical calculations data analysis. This is a widely used user friendly software which helps in storing the data, numerical calculation, graphs and charts, dashboard reporting etc. Below are the top 8 best Uses of Excel spread sheet software:- 1. Numerical calculations:- This type of software … Read more