Excel VBA listbox search as you type from all sheets

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, […]

VBA ColorIndex list and macro to list color index

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 […]

Dynamic Label and Textbox during runtime in excel vba

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.