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
In userform we can insert Labels and Textboxes while designing. In this post you can learn how to create the label and text box dynamically during the runtime with the help of command button.
Recently I received a question from our reader through our facebook page about how to highlight selected cell in excel with color. I have crated this short VBA codes for following to answer his question: VBA code to highlight selected cell in a single sheet. VBA code to highlight selected cell in all sheets VBA … Read more
In case if you have a large list of employee data in a sheet and you want to select one employee details in main sheet based on the employee number. You can put a vlookup table and the details can be retrieved based on id in that table as below. But in case if you … Read more
What is MAC address? A media access control address (MAC address) is a unique identification assigned to a device network interface controller (NIC) for communication at the data link layer of a network segment. In simple words, this is a unique identification for a device or computer in a network for communication. You can get … Read more
Excel vba pdf – VB Code: 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 … Read more