About listbox properties.

EzzatHesham

New Member
Joined
Jun 10, 2022
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
Hello everyone,
The listbox has a match first letter property, but I'm wondering if it has a that property to search with any part of name or any letter existing in the name, like example:
"Alexander Wang"
Listbox will read the first letter a then l then e untill catch the name, but if i write w a first letter from wang, listbox doesn't catch it, and sometimes I haven't all the name, just a middle name or surname, because that i asking if there that property i mentioned in listbox properties
Thanks for advice and help 😊💜
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
No, nothing like that is built in. The way this is typically handled is to add a textbox, and as the user types into the textbox you would have custom code (Sub TextBox1_Change) to do the desired matching and select the appropriate item(s) in the listbox.
 
Upvote 0

Forum statistics

Threads
1,215,025
Messages
6,122,732
Members
449,093
Latest member
Mnur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top