VBA UI UX-3: Advanced Autocomplete Suggestions, Predictive search for Excel UserForm

[@dinawangjkiu9712]

This is intuitive and flawless. Keep it up!

[@VBAA2Z]

Much appreciated!

[@prodajemsuvisno6112]

I really like the professional look of the form!

[@VBAA2Z]

thank you!

[@hipnobe]

I love this one. It makes your forms looking very professional

[@VBAA2Z]

Thanks!

[@axelamoe]

Bought the UIX package, wanted to support. Can't wait to receive it and start the fun

[@VBAA2Z]

Thank you so much for your support. Your encouragement will help me put more time into research and share more tutorials free for everyone.

[@Chewangz]

This has helped me on my project. Thank you!

[@VBAA2Z]

Glad it helped!

[@Nphum]

amazing work my friend!

[@VBAA2Z]

Thank you! Cheers!

[@pedche5790]

Very interesting videos, thank you so much!

[@VBAA2Z]

Glad you enjoyed it!

[@shellynomis7368]

Thank you so much.
This is great series. All VBA enthusiast should watch

[@VBAA2Z]

Glad you think so! thanks for watching and for your support.

[@ravisuryawanshi2516]

Great help from you buddy, Looking forward for more vba dashboards

[@VBAA2Z]

Thanks Ravi. I'll definitely cover those topics in coming videos.
Regards.

[@atil2475]

Same here

[@mohammedraisdeen6328]

Great Project, Thank you.

[@VBAA2Z]

Glad you like it!

[@kennanbarryboborol3744]

Thank you for this wonderful tutorial.

[@VBAA2Z]

You are so welcome!

[@YahyaTalib-x7d]

I'm impressed with your videos..I got a lot of knowledge from you..thank you

[@VBAA2Z]

Glad to hear that!

[@atil2475]

Big applause for you sir. You're super. Keep it up.

[@hwanlee9110]

Thank you for sharing such a great work.

[@VBAA2Z]

Thank you too!

[@KamayoAko]

what a brilliant tutorial. thank you for sharing.

[@VBAA2Z]

Thanks Kamayo. Thanks for your support.

[@GiselleBrat]

Great series. Thank you Sir.

[@VBAA2Z]

Thanks for watching!

[@johng5295]

Thanks in a million. Great content. Awesome imagination. Grade: A++💥

[@VBAA2Z]

Many thanks!

[@NancyCa198-a]

Thanks for great tutorials.

[@VBAA2Z]

Glad you like them!

[@augen1234]

another great video thanks for sharing

[@VBAA2Z]

Thanks for watching

[@bnancy3699]

This is extremely useful. Thank you.

[@andresbambarenalcala8866]

Thank you very much for your excellent and useful contribution

[@VBAA2Z]

You are welcome!

[@sonuwarsi738]

Learning a lot from you ... Thanks for sharing the knowledge 😊

[@VBAA2Z]

Glad to hear that

[@pamchamzell4489]

Very useful thanks for the video 😊

[@carlossaavedra2950]

Very good video. Regards...

[@VBAA2Z]

Thank you very much!

[@johng5295]

Thanks in a million. Great content. Awesome imagination. I have subscribed. Grade: A++💥

[@VBAA2Z]

Awesome, thank you!

[@saxman678]

Awesome tutorials. Thank you so much. I have a question concerning this autocomplete project. Can it be made to work directly on a worksheet instead of a form ?

[@VBAA2Z]

You're welcome. Yes, you can use ActiveX Controls which can be inserted via Developer Ribbon tab.

[@lesfilsdeclo]

Génial
Merci

[@VBAA2Z]

Thanks!

[@oguzturkyilmaz543]

Thank you thank you thank you

[@VBAA2Z]

You are very welcome

[@sefaelmas8501]

thank you. great video

[@sefaelmas8501]

I don't understand the language you speak, but what you do is understandable.

[@VBAA2Z]

Glad it helped

[@leegarrett1908]

Hi thanks for this is there a project file for ux-3 or your ux -5 as can't see this as an option. Thanks

[@AlessandroCometti-t5t]

Hi, do you still send the emails with the templates?

[@SidauChe]

thnk you sirji

[@VBAA2Z]

Most welcome!

[@pedie131]

thanks!

[@VBAA2Z]

No problem!

[@Ferris-bu5yb]

thank you so much

[@VBAA2Z]

You're welcome!

[@victorionescu7653]

How we can run this workbook on a 64 bit systems?

[@VBAA2Z]

Hi Victor, thanks for checking our channel.
If you're receiving Compile error because of the bit, please update all declaration as mentioned in this article. We'll talk more about this topic in days to come. We have more episodes coming this weenkend. Please watch out. Also please do not forget to subscribe.
for example, add 'PtrSafe' after the word 'Declare' for API in Userform module.
from - >
Private Declare Sub Sleep Lib "kernel32" (ByVal ms as Long)
to - >
Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal ms As LongPtr)
docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/compile-error-editing-vba-macro

[@Shriny100]

I want to use this functionality to search inside10 pdf files in a folder. And get Name and page number of the string match found. Can you guide me or give me some hint please. Thanks

[@VBAA2Z]

You can combine this feature with reading PDF data th-cam.com/video/uc6palG76Y8/w-d-xo.html

[@saitex3098]

sir , need autocomplete textbox with 3 Columns

[@VBAA2Z]

You should be able to follow same approach

[@melivo853]

Thanks

[@VBAA2Z]

Welcome

[@lamdinliuchewang3610]

thank you

[@VBAA2Z]

You're welcome

[@Chawangs]

useful really

[@VBAA2Z]

Glad you think so!

[@Shriny100]

Great tutorial. Thanks so much! Is there a ready to download code for this? But we can type also.

[@VBAA2Z]

thank you.
Please refer to Project ID 010 and 011 from this link vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

[@sajinj1543]

@@VBAA2Z can't find download free link

[@giorgiorovelli1542]

Where do I find the playlist "Professional UI/UX"?

[@VBAA2Z]

please check here th-cam.com/video/p93JRjTFWmc/w-d-xo.html

[@sajinj1543]

Can't find free download link of project. Please share

[@cuongnguyen-ci8xj]

how to download.. thank you , I really need. please

[@VBAA2Z]

please check all downloads from here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

[@DrPPrabu]

its not working with 64 bit .. please help me

[@VBAA2Z]

Please check below link.
vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html

[@ryannugraha807]

how to be able suggesting not only based on the first letter?

[@ryannugraha807]

i have an example:
Ballpoint extra
super ballpoint
i want all sentences that contains "ballpoint appear on the result listbox

[@VBAA2Z]

to match starting text try
textbox1.value & "*"
to match any text try
"*" & textbox1.value & "*"

[@ryannugraha807]

@@VBAA2Z where i have to input that line? Into function search_text?

[@VBAA2Z]

@@ryannugraha807 you'll include it in 'search_text' function.

[@VBAA2Z]

here is the exact syntax.
If LCase(xvalue) Like "*" & LCase(textTosearch) & "*" = True Then

[@thehgamers]

This doesnt work for me
nothing happens

[@VBAA2Z]

possible the data is not loaded to array first.
want to share your code?

[@susilsxzen-ff1zn]

Thank you

[@VBAA2Z]

You're welcome

[@Sicilia-rn1hc]

thanks

[@VBAA2Z]

You're welcome!

[@wangniperinmai]

thank you

[@VBAA2Z]

Welcome!