Advanced Excel UserForm with real-life projects. Modern UI For beginners and professionals

Advanced Excel UserForm with real-life projects. Modern UI For beginners and professionals

VBA A2Z

3 года назад

120,307 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Cherengliu
Cherengliu - 26.08.2023 22:34

Your works are really amazing. Thank you Sir.

Ответить
Sandler Cruise
Sandler Cruise - 14.08.2023 16:37

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?

Ответить
Suang Suanglee
Suang Suanglee - 28.07.2023 14:15

Amazing thanks a million

Ответить
Samuel Nyenkan
Samuel Nyenkan - 14.07.2023 23:17

Your lessons are so amazing, now I am grabbing on

Ответить
Justin Fitzpatrick
Justin Fitzpatrick - 09.07.2023 09:51

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!

Ответить
Stacy Scudder
Stacy Scudder - 09.06.2023 23:59

Awesome! Thanks so much

Ответить
Room Room Car 45
Room Room Car 45 - 23.05.2023 21:40

I am completely new to all of this but after watching, I’m curious how big of a file this creates. Amazing work though!

Ответить
RobReb Duggan
RobReb Duggan - 15.05.2023 11:14

Brilliant videos

Ответить
NeN CloBeldz
NeN CloBeldz - 09.05.2023 11:24

No source code sharing. Not good.

Ответить
Ali Alizadeh
Ali Alizadeh - 06.05.2023 05:37

Thanks all ....

Ответить
Pavel Pravikov
Pavel Pravikov - 06.04.2023 20:44

great work

Ответить
Brad
Brad - 05.04.2023 13:36

great video keep it up!

Ответить
WorthlessServant07
WorthlessServant07 - 02.04.2023 21:35

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.

Ответить
xhavier j
xhavier j - 26.03.2023 17:45

can you plz add time stamps in this video

Ответить
Max
Max - 24.03.2023 13:02

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?

Ответить
Ning San
Ning San - 15.03.2023 15:53

Wow 🤩 never such design and creativity

Ответить
M El
M El - 10.03.2023 17:21

Nice work, the process to download the sample files is not easy though. But you are doing a neat job. it worth it

Ответить
Giselle Brat
Giselle Brat - 09.03.2023 19:29

Its amazing, thanks so much for sharing

Ответить
Josh Kingiu
Josh Kingiu - 27.02.2023 19:45

superb, thank you

Ответить
Susils Xzen
Susils Xzen - 26.02.2023 18:55

This is amazing 😍
Keep it up

Ответить
Katu'siime Beren
Katu'siime Beren - 25.02.2023 07:38

Never learnt so much in one video. Thanks

Ответить
Pepi studios
Pepi studios - 23.02.2023 23:43

Wow... I learned so much. There are so many things here that I can use. Thanks!

Ответить
Chekheng Ki
Chekheng Ki - 23.02.2023 20:56

Userform to SuperForm - This looks amazing! especially done from Excel VBA Userform. Great work!

Ответить
Alex Chan
Alex Chan - 21.02.2023 17:55

Thank you for the guide that set the label invisible and then the textbox set focus. That's what i want! really appreciate!

Ответить
Sidau Che
Sidau Che - 04.02.2023 00:59

thank you so much for brilliant video

Ответить
Bonzabenchtops
Bonzabenchtops - 21.01.2023 07:39

Fantastic!

Ответить
Chewang
Chewang - 11.01.2023 22:17

Very creative ❤

Ответить
Sidaubo
Sidaubo - 23.12.2022 20:49

Super Creative and Innovative!!!

Ответить
REST IN PEACE
REST IN PEACE - 08.10.2022 10:10

there is ONE PROBLEM with Excel and VBA , runtime is slow as fuck. lagging software expecially with large dataset.

Ответить
Ekilu Newmai
Ekilu Newmai - 27.09.2022 01:18

Your videos have helped me complete my projects. Thank you so much

Ответить
Usman Yahaya
Usman Yahaya - 06.09.2022 05:28

This is really amazing. I'm a CS student diving to data analysis. Working on Sharpening my Excel skills. Your page is really amazing. Thanks so much for this. I'm having problem downloading the source code for this project,or is it not free anymore? I would really love to have the code to follow up efficiently. Please help with a link sir.

Ответить
Jesus Ribeiro
Jesus Ribeiro - 14.08.2022 13:56

Thanks. I'd like to level-up my macro projects' design at work and this is very helpful.

Ответить
Serafettin Unsal
Serafettin Unsal - 16.07.2022 20:25

Thank you for this great tutorial. I just found your videos by coincidence and very happy about it.

Ответить
jason emans
jason emans - 21.06.2022 01:42

excellent series. now to jump through the hoops to get the source code...

Ответить
Ssenkandwa Francis
Ssenkandwa Francis - 19.05.2022 10:26

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

Ответить
Dave Will Jean-Louis
Dave Will Jean-Louis - 09.05.2022 17:22

Very nice!

Ответить
Wikamdio Pekiang
Wikamdio Pekiang - 18.04.2022 16:57

this is absolutely brilliant. Thanks a million!!!!

Ответить
Josh McCoy
Josh McCoy - 11.04.2022 18:29

Amazing video, most in-depth and concise explanations out there! Keep up the awesome videos

Ответить
Mohamed Farouk Elwahy
Mohamed Farouk Elwahy - 07.04.2022 03:47

Very Very niceee man

Ответить
Umair Salik
Umair Salik - 02.04.2022 10:31

Amazing

Ответить
Fit & Fabulous Life
Fit & Fabulous Life - 06.03.2022 03:12

What do u think about future of VBA. People say its a dying technology.

Ответить
Fit & Fabulous Life
Fit & Fabulous Life - 05.03.2022 04:32

Best UI guide

Ответить
shaojuan zhang
shaojuan zhang - 21.02.2022 00:46

Thanks for sharing and I really loved it.

Ответить
Antonio Rabadán
Antonio Rabadán - 19.02.2022 13:41

Muy bueno

Ответить
Prince Kumabio
Prince Kumabio - 18.02.2022 07:11

THIS IS GREAT

Ответить
Relaxed Music World
Relaxed Music World - 16.02.2022 00:42

how confusion vba code to protect it.

Ответить
Roland
Roland - 05.02.2022 21:32

This series is best of all. Super thanks

Ответить
Shadi Sherif
Shadi Sherif - 19.11.2021 22:34

perfect

Ответить
Dan
Dan - 03.11.2021 23:34

Cool video. Lots of stuff to learn !!

Ответить
Vinícius Dias
Vinícius Dias - 16.08.2021 01:48

Show!

Ответить