My friend. You’ve created the perfect video for what I am looking for. I’m not even halfway through and you’ve already inspired me to upgrade almost every one of my projects. Thank you so much for providing such valuable content. Truly one of the best videos I’ve seen on this topic.
This video series is really phenomenal...it walked me through so many things I've wanted to incorporate since I started dabbling in dashboards for my job. Thank you so much!
How would you create a userform for a more complicated data stucture? I am working with data where there are mutiple telephone numbers, customer notes, email addresses etc. So I have various tables that I need to pull/push data from/to. Currently, I have temp tables where I store information that the user inputs/changes but it gets complicated when they hit save because I now need to either update or create new records depending on if the record(s) already exist. So before saving the temp data I will have to search for each record to see if it exists and then decide what to do with it... Or, maybe I should keep a log in the temp table. e.g. whether the record needs to be created or updated. Any thoughts?
Great job. My only comment is that you could slow down just a little bit. It is hard, sometimes, to see where you are clicking and the mouse is dashing all over the screen. This is only a small point though.
I have a complex excel book which contains most of the functionality in spreadsheet coz I have to make it compatible with MAC also. Do you think Listview control can be a replacement of using a spreadsheet and can also work on MAC?
Does this video still applicable to newer version of microsoft excel? Cause I do really wanna learn excel with VBA to make my work a lot easier once the excel file get programmed correctly.
Hey, first I’d like to thank you for this video, I watched/referred this video so many times and it helped me a lot. Now, I have a question: I’d like to keep a bunch of stuff in my userform (100s of frames, labels and other objects) which are overlapping on each other. So It’s becoming very difficult to work on those, is there a way we can hide/unhide the frames on the userfom ?? Because every frame I use covers the entire userform, and there are many objects inside each frame. So I wanted hide all other frames except the one I’m working on, and again I’ll hide this and unhide another frame which I’ll work on and so on… I’m not asking to hide/unhide these frames after running the VBA, I know how to do that. I want to know if it’s possible to hide while we are coding.
You're most welcome. I am not aware of way to hide objects in Design mode. My practice is to move the UI controls off to the side, work with them there, and then position them during runtime or use multiple pages or multiple forms.
@@VBAA2Z Thank you so much for your response man, I appreciate it. And yep that’s how I’m doing it but multi page doesn’t work for my case. Thanks 🙏 a lot
Hello Mr Lung, I kindly request you to make for me a video illustrating how to print multiple student's reports. I wish to make it like I can specify to print from report one to report number 50. Thanks
This is great. Can we create a form like this in word document too and update the documents with inputs from it and export the final doc to pdf? Kindly show some example.
Check this tutorial. it give you good idea on how to achieve what you're looking for. and yes, you can also add / design UserForm in same fashion. All the best. ua-cam.com/video/RQgOxv6nrE0/v-deo.html
Great video! I implemented the Userform LogIn! Despite the code snippet Apllication.Visible = False in the Workbook open event i see the excel sheets, before the Userform pops up, this defeats the purpose of a login windows. Do you know how to fix it?
@@VBAA2Z i do not want a standalone app, i just want to have a login userform for my excel. So when opening the excelfile only the login should appear. Is this possible?
Interested to become VBA Pro? Here is 100% free guided e-course with Real-life projects. Sign-up to participate, get assignments and a certificate:- bit.ly/3eX8tzl
How to make it dynamic when we want the forms to be used by others? Since you have kept all images in one folder it was easy. But what if we have to distribute the form for multiple user scenario? Thank you! I like the videos so far.
Hi mr Nice work thank you very much How can I show table inside userform and connect to table in excel sheet edit data like access form with table Thank you very much
do you have sample video for userform that can upload excel list then it will appear to the excel worksheet of userform database? thanks in advanced if you have time for this question.
Hi I got an error with your code saying "the code in this project must be updated for the use of 64 bit system". Could you please advise what could be wrong ? BTW, I'm using the most updated office 365
Please check this link. It'll guide you to update for 64-Bit Excel. Note - > Date Picker and ListView won't work for 64-Bit Excel. vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html
Is there a way to code where instead of going textbox1.value = cell (in excel) Like to be able to do programatically when adding or editing information in the sheet using the userform?
small example below. textbox1.value = range("A1").value ' to fill textbox1 with cell value range("A1").value = textbox1.value ' to fill cell with textbox1 value
@@VBAA2Z yes thanks. What I mean is like at the 50 minute mark you show that instead of doing a code for each image to create one called aImage to then modify each of the buttons. I was wondering if there was something similar to that when inputting or editing data in a userform. Instead of tEXTBOX1.VALUE=Range("A1") Like for each control in this userform and then put it into the worksheet and vice versa, show the worksheet data in the userform.
My friend. You’ve created the perfect video for what I am looking for. I’m not even halfway through and you’ve already inspired me to upgrade almost every one of my projects. Thank you so much for providing such valuable content. Truly one of the best videos I’ve seen on this topic.
You're very welcome!
0:00 - 31:27 : Log-in interface
32:35 - 1:12:55 : Special effects to controls and transition effects
1:13:20 - 1:33:40 :Record expenses
1:34:20 - 1:45:20 : Create new report
Thanks!
Never seen that much features in one teaching, amazing Pamai.
Thanks Ben!
Userform to SuperForm - This looks amazing! especially done from Excel VBA Userform. Great work!
Thanks a lot!
most underrated channel. thank you for amazing tutorial!!!!
I appreciate that!
Never learnt so much in one video. Thanks
Glad to help
This video series is really phenomenal...it walked me through so many things I've wanted to incorporate since I started dabbling in dashboards for my job. Thank you so much!
You're so welcome!
Your lessons are so amazing, now I am grabbing on
Glad you like them!
Simply "WOW", it's amazing. Thank you so much for sharing such kind of knowledge.
Glad you liked it! thanks for watching.
Sir, this is the best userform series ever. I already watched them in prior publish and helped me in my projects. Many Thanks.
You are most welcome
Have to totally agree! Also following your process and approach was super helpful.
Sadly due to time constraints I haven't used all (yet! ^^)
Thank you for the guide that set the label invisible and then the textbox set focus. That's what i want! really appreciate!
Glad it helped!
Thank you for this great tutorial. I just found your videos by coincidence and very happy about it.
Glad it was helpful!
Super Creative and Innovative!!!
Thank you! Cheers!
Wow 🤩 never such design and creativity
Thank you! Cheers!
Wow really amazing features. Will come back and watch more. Cheers 👍
Thanks for visiting
This series is best of all. Super thanks
Thanks!
Best vba and Excel vidéo Ever 🎉🎉🎉🎉🎉
excellent series. now to jump through the hoops to get the source code...
Thanks for supporting the channel. Much appreciated.
Wow... I learned so much. There are so many things here that I can use. Thanks!
You are so welcome!
Your videos have helped me complete my projects. Thank you so much
Glad I could help!
You taked the vba to another level 👏
Thanks!
This is amazing 😍
Keep it up
Thanks 😄
Your works are really amazing. Thank you Sir.
You are most welcome
i love your videos especially on automation and dynamic designs
I appreciate that!
this is absolutely brilliant. Thanks a million!!!!
You're very welcome!
Just start to watch this amazing user form and subscribed your channel.
Thanks for the sharing
Welcome aboard! all the best.
Dear Friend,
This is amazing! Thanks a lot for the effort and sharing! NAMASTE 🙏
You are very welcome. Namaste 🙏
Amazing video, most in-depth and concise explanations out there! Keep up the awesome videos
Much appreciated!
Wow this is amazing. Thanks for sharing your knowledge
My pleasure. thanks for watching
What a video man, Great job!
Glad you enjoyed it!
loved this series. thanks again.
Glad you enjoyed it
Keep sharing all these great contents!
More to come!
Thanks for sharing and I really loved it.
Glad you enjoyed it!
Great content! Looking forward to this series.
Glad to hear it!
Excellent user form programming. Please make a video on automating desktop application too.
Thanks for watching and for your suggestion.
Cool video. Lots of stuff to learn !!
Glad you liked it!
You are the ⭐start bro
Thank you bro!
Great compilation!
This is great, thanks for sharing your knowledge 👍
Glad you enjoyed it!
How would you create a userform for a more complicated data stucture?
I am working with data where there are mutiple telephone numbers, customer notes, email addresses etc. So I have various tables that I need to pull/push data from/to.
Currently, I have temp tables where I store information that the user inputs/changes but it gets complicated when they hit save because I now need to either update or create new records depending on if the record(s) already exist. So before saving the temp data I will have to search for each record to see if it exists and then decide what to do with it...
Or, maybe I should keep a log in the temp table. e.g. whether the record needs to be created or updated.
Any thoughts?
Use Multi pages and tabs within multiples if you need to further segregate read / write
Such a great video. Looking forward to completing my own project. Thanks!
You can do it! All the best!
Great job. My only comment is that you could slow down just a little bit. It is hard, sometimes, to see where you are clicking and the mouse is dashing all over the screen. This is only a small point though.
thank you so much for brilliant video
You're very welcome!
Awesome! Thanks so much
Our pleasure!
Great tutorial.
Next, I will try it with Libreoffice Calc also.
thanks. all the best!
What a video man ! Amazing
Thanks a ton!
Very creative ❤
Thank you! Cheers!
Its amazing, thanks so much for sharing
Glad you like it!
Brilliant videos
thank you!!!
Best UI guide
Thanks Farhan!
I have a complex excel book which contains most of the functionality in spreadsheet coz I have to make it compatible with MAC also. Do you think Listview control can be a replacement of using a spreadsheet and can also work on MAC?
Thanks. I'd like to level-up my macro projects' design at work and this is very helpful.
Great to hear!
great work
Many many thanks
Nice work, the process to download the sample files is not easy though. But you are doing a neat job. it worth it
Thanks a lot!
For the beginning login module, do you as a designer to assign password for user? Or user will use the same Windows Login password?
I wish to use these User Interfaces and make my Excel Forms in a professional way. I hope these videos will be very much useful.
I hope so too!
superb, thank you
Welcome 😊
Does this video still applicable to newer version of microsoft excel? Cause I do really wanna learn excel with VBA to make my work a lot easier once the excel file get programmed correctly.
Very professional video!👌
Thanks! 😃
Hey, first I’d like to thank you for this video, I watched/referred this video so many times and it helped me a lot.
Now, I have a question: I’d like to keep a bunch of stuff in my userform (100s of frames, labels and other objects) which are overlapping on each other. So It’s becoming very difficult to work on those, is there a way we can hide/unhide the frames on the userfom ?? Because every frame I use covers the entire userform, and there are many objects inside each frame.
So I wanted hide all other frames except the one I’m working on, and again I’ll hide this and unhide another frame which I’ll work on and so on…
I’m not asking to hide/unhide these frames after running the VBA, I know how to do that. I want to know if it’s possible to hide while we are coding.
You're most welcome.
I am not aware of way to hide objects in Design mode. My practice is to move the UI controls off to the side, work with them there, and then position them during runtime or use multiple pages or multiple forms.
@@VBAA2Z Thank you so much for your response man, I appreciate it.
And yep that’s how I’m doing it but multi page doesn’t work for my case. Thanks 🙏 a lot
Thank you so much. Great video!
You're very welcome!
Very nice!
Thank you! Cheers!
Thanks for sharing your amazing skills.
Thank you! Cheers!
Very professional video!
Thank you!
Great training resource
Thanks!
Hello Mr Lung, I kindly request you to make for me a video illustrating how to print multiple student's reports. I wish to make it like I can specify to print from report one to report number 50. Thanks
Ok I will try
@@VBAA2Z Dearly waiting for you my mentor.
Very interesting video
Thanks
Glad you enjoyed it
Thanks Alot For This Aswome Tutorial
You're welcome!
Thanks for sharing. Will come back and finish later. Looks very promising.
Hope you enjoy it!
What do u think about future of VBA. People say its a dying technology.
As long as Excel exist so will VBA :)
Learn multiple languages based on your requirements.
Amazing
Thank you! Cheers!
Fantastic!
Thank you! Cheers!
Very Very niceee man
Thank you so much 😀
THIS IS GREAT
thanks!
great video keep it up!
Thanks!
Thanks much sir.... Make flashing or blinking text in userform
thanks for suggestion. give this a shot. You can add GIF and make it flash.
ua-cam.com/video/ck3NIB-TzR0/v-deo.html
many thanks!
You're welcome!
You are amazing!
Thanks Krishna.
Thanks for this!
No worries!
Very useful, thank you
Glad it was helpful!
This is great. Can we create a form like this in word document too and update the documents with inputs from it and export the final doc to pdf? Kindly show some example.
Check this tutorial. it give you good idea on how to achieve what you're looking for.
and yes, you can also add / design UserForm in same fashion. All the best.
ua-cam.com/video/RQgOxv6nrE0/v-deo.html
Good
Thanks
Im impressed!
thanks for watching Jesper.
Thanks for this video.
you are most welcome!
Great video! I implemented the Userform LogIn! Despite the code snippet Apllication.Visible = False in the Workbook open event i see the excel sheets, before the Userform pops up, this defeats the purpose of a login windows. Do you know how to fix it?
If you're looking for standalone app try the .net series in the channel.
You can also use Access UI, Word UI etc.
@@VBAA2Z i do not want a standalone app, i just want to have a login userform for my excel. So when opening the excelfile only the login should appear.
Is this possible?
@@M1and5M Excel file will always load up first then your file which will trigger your code so there will be bit of gap before login form shows up.
it is really amazing
thanks!
Interested to become VBA Pro? Here is 100% free guided e-course with Real-life projects. Sign-up to participate, get assignments and a certificate:- bit.ly/3eX8tzl
How to make it dynamic when we want the forms to be used by others? Since you have kept all images in one folder it was easy. But what if we have to distribute the form for multiple user scenario? Thank you! I like the videos so far.
Google Drive Empresarial
Amazing thanks a million
You're welcome!
Thanks for video
Most welcome
Hi mr
Nice work thank you very much
How can I show table inside userform and connect to table in excel sheet edit data like access form with table
Thank you very much
try ListBox or custom table. ua-cam.com/video/JolVwS3emYg/v-deo.html
Thank you very much
But can I edit data inside this table
like access table inside form
Interesting videos my friend!
Many thanks
do you have sample video for userform that can upload excel list then it will appear to the excel worksheet of userform database? thanks in advanced if you have time for this question.
please check E2 of this series
ua-cam.com/video/p93JRjTFWmc/v-deo.html
Amazing tutorials and examples! Now I can see that forms are the field I need to improve my skills :)
Glad to hear, thanks for watching
i know Im kinda randomly asking but do anyone know a good site to watch new series online ?
@Lee Wesley Meh atm i have been using Flixportal. You can find it thru google :) -finn
@Finn Callan Thanks, signed up and it seems like a nice service :D I appreciate it!
@Lee Wesley No problem xD
Muy bueno
thanks!
Hi I got an error with your code saying "the code in this project must be updated for the use of 64 bit system". Could you please advise what could be wrong ? BTW, I'm using the most updated office 365
Please check this link. It'll guide you to update for 64-Bit Excel.
Note - > Date Picker and ListView won't work for 64-Bit Excel.
vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html
set the language of the video as English. Then auto-generated subtitle will be available.
Is there a way to code where instead of going textbox1.value = cell (in excel) Like to be able to do programatically when adding or editing information in the sheet using the userform?
small example below.
textbox1.value = range("A1").value ' to fill textbox1 with cell value
range("A1").value = textbox1.value ' to fill cell with textbox1 value
@@VBAA2Z yes thanks. What I mean is like at the 50 minute mark you show that instead of doing a code for each image to create one called aImage to then modify each of the buttons. I was wondering if there was something similar to that when inputting or editing data in a userform. Instead of tEXTBOX1.VALUE=Range("A1") Like for each control in this userform and then put it into the worksheet and vice versa, show the worksheet data in the userform.
This is amazing staff. Where can I download the sample code and files?
pamaitech.com/downloads/
You download portals are down when will it be back up
please download from here ua-cam.com/video/p93JRjTFWmc/v-deo.html
Bravo