Skip to content

Excelhub

  • Home
  • Utilities
  • Excel Basics
  • Function 100+
  • Tricks
  • Visual Basic

visual basic

Excel VBA listbox search as you type from all sheets

by Excelhub
Search result in listbox 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, … Read more

Categories Visual Basic Tags visual basic 1 Comment

VBA ColorIndex list and macro to list color index

by Excelhub

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

Categories Visual Basic Tags visual basic Leave a comment

Dynamic Label and Textbox during runtime in excel vba

by Excelhub

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.

Categories Visual Basic Tags visual basic Leave a comment
Enter your email address:

Tags

Date and time Financial Information Logical Lookup and reference Math and trigonometry Statistical Text visual basic Vlookup
© 2023 Excelhub • Built with GeneratePress