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!

[@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.

[@hipnobe]

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

[@VBAA2Z]

Thanks!

[@Nphum]

amazing work my friend!

[@VBAA2Z]

Thank you! Cheers!

[@Chewangz]

This has helped me on my project. Thank you!

[@VBAA2Z]

Glad it helped!

[@YahyaTalib-x7d]

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

[@VBAA2Z]

Glad to hear that!

[@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

[@pedche5790]

Very interesting videos, thank you so much!

[@VBAA2Z]

Glad you enjoyed it!

[@atil2475]

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

[@mohammedraisdeen6328]

Great Project, Thank you.

[@VBAA2Z]

Glad you like it!

[@kennanbarryboborol3744]

Thank you for this wonderful tutorial.

[@VBAA2Z]

You are so welcome!

[@sonuwarsi738]

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

[@VBAA2Z]

Glad to hear that

[@carlossaavedra2950]

Very good video. Regards...

[@VBAA2Z]

Thank you very much!

[@augen1234]

another great video thanks for sharing

[@VBAA2Z]

Thanks for watching

[@GiselleBrat]

Great series. Thank you Sir.

[@VBAA2Z]

Thanks for watching!

[@KamayoAko]

what a brilliant tutorial. thank you for sharing.

[@VBAA2Z]

Thanks Kamayo. Thanks for your support.

[@hwanlee9110]

Thank you for sharing such a great work.

[@VBAA2Z]

Thank you too!

[@NancyCa198-a]

Thanks for great tutorials.

[@VBAA2Z]

Glad you like them!

[@johng5295]

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

[@VBAA2Z]

Many thanks!

[@johng5295]

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

[@VBAA2Z]

Awesome, thank you!

[@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

[@andresbambarenalcala8866]

Thank you very much for your excellent and useful contribution

[@VBAA2Z]

You are welcome!

[@pamchamzell4489]

Very useful thanks for the video 😊

[@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.

[@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 kzbin.info/www/bejne/q5SZoZSifJxpj5o

[@bnancy3699]

This is extremely useful. Thank you.

[@lesfilsdeclo]

Génial Merci

[@VBAA2Z]

Thanks!

[@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

[@oguzturkyilmaz543]

Thank you thank you thank you

[@VBAA2Z]

You are very welcome

[@AlessandroCometti-t5t]

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

[@VBAA2Z]

please visit pamaitech.com

[@sefaelmas8501]

thank you. great video

[@sefaelmas8501]

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

[@VBAA2Z]

Glad it helped

[@giorgiorovelli1542]

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

[@VBAA2Z]

please check here kzbin.info/www/bejne/pmqWe4WgiauKo8U

[@sajinj1543]

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

[@SidauChe]

thnk you sirji

[@VBAA2Z]

Most welcome!

[@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

[@saitex3098]

sir , need autocomplete textbox with 3 Columns

[@VBAA2Z]

You should be able to follow same approach

[@pedie131]

thanks!

[@VBAA2Z]

No problem!

[@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

[@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

[@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

[@melivo853]

Thanks

[@VBAA2Z]

Welcome

[@Ferris-bu5yb]

thank you so much

[@VBAA2Z]

You're welcome!

[@Chawangs]

useful really

[@VBAA2Z]

Glad you think so!

[@lamdinliuchewang3610]

thank you

[@VBAA2Z]

You're welcome

[@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!