Your VB Tutor

Пікірлер

@michaelanderson2939 2 сағат бұрын

New subscriber here. Love the vid mate. Anyway you could make a download example. Please show more this is awesome and just what I was looking for.

@YourVBTutor Сағат бұрын

Thanks for the sub. I haven't made the file downloadable as of yet, as I think it's more valuable for people to do the work to practice it. In future I may provide a method for downloading the workbooks. Thanks for watching 😊

@claudineyribeiro518 3 күн бұрын

Hi bro, I'm running a youtube channel sharing knowledge about opengl with excel through VBA. And i hope to develop advanced graphicals menu and userforms . Very Cool!!

@YourVBTutor 3 күн бұрын

I had a quick look through some of your videos. That's some seriously impressive stuff! Keep it up!

@riaannel3053 3 күн бұрын

Great content, but you are flying through this at the speed of light !! Any person with no knowledge of these processes will loose interest in 2 minutes, as you do not explain it to people. You just show what you are doing, but not explaining anything.

@YourVBTutor 3 күн бұрын

I appreciate that the speed isn't for everyone, feel free to slow down the video or intermittently pause to catch up. Thanks for watching. 😊

@TheLaopi 4 күн бұрын

Amazing can you share pls

@YourVBTutor 4 күн бұрын

I believe it's always best to do the work yourself for the best learning outcome. Thanks for watching 🙂

@norro21 4 күн бұрын

Just don't do this. The benefit of excel is that it already has a UI that is common across all documents. Anything you make even if it is 'better' in your opinion is different and something new to learn. If you want to build a unique interface for your app there are far better ways to do that. As a web app for multiple devices possibly the optimal. But there are easy start options eg. Using Microsoft forms for input and power automate for any workflow, leaving excel to what it is designed for, to analyse/manipulate the data

@YourVBTutor 4 күн бұрын

You're absolutely entitled to your opinion. I've made a living from building applications in Excel, so I know there are many people that still want applications built in Excel. I'm just here to share my knowledge with the community. Thanks for watching 🙂

@hrmnpsrffn 5 күн бұрын

Thank you, sir!

@YourVBTutor 5 күн бұрын

Thanks for watching 🙂

@michaeldingee743 5 күн бұрын

Code errors out at this line Set pptShape = pptSlide.Shapes(pptSlide.Shapes.Count) Shaoe ( Unknown Member) : Integer out of range. 0 is not in the valid range of 1 to 0

@YourVBTutor 5 күн бұрын

It looks like the shape isn't copying over to PowerPoint properly. Make sure you have a shape selected in the workbook before running the macro. Also change false to true when adding the presentation to be able to see the PowerPoint application, which should help you diagnose what's going wrong. Let me know how you go.

@michaeldingee743 5 күн бұрын

@@YourVBTutorI have a shape selected, I had already set this to Set pptPres = pptApp.Presentations.Add(msoTrue), I also changed the .Fill.ForeColor.RGB = RGB(34, 139, 34) to a Green color and put a breakpont at pptShapeRange.MergeShapes msoMergeSubtract. Powerpoint opens and the green shape is there. It errors at the next line of code.

@YourVBTutor 5 күн бұрын

Sorry that you're experiencing issues. Feel free to send me an email with a screenshot of the code so I can diagnose the issue properly. [email protected]

@darrelwatson2276 7 күн бұрын

Wow! Great video! I’m still new to VBA, but I used one of your other videos to build a LogMessage into one of my applications. Very Helpful, thank you!

@YourVBTutor 7 күн бұрын

Great to hear! Logging is a fantastic tool for professional app building. Well done! Thanks for watching 🙂

@toinevanderwielen9508 7 күн бұрын

Great! That is really cool! Thank u very much!😊

@YourVBTutor 7 күн бұрын

Glad you enjoyed! Thanks for watching.

@GOKUGRINDGAMING 8 күн бұрын

❤❤❤

@YourVBTutor 8 күн бұрын

Thanks for watching 😊

@AndrewWhite-w5g 8 күн бұрын

👏👏👏👏Excellent! A little too fast for my ability. Any chance of getting the code?

@YourVBTutor 8 күн бұрын

Thanks for watching. Glad you enjoyed. Feel free to pause throughout the video to give yourself a chance to copy the code. 😊

@CoderzF1 7 күн бұрын

@@YourVBTutor i agree with this statement. you learn the code better by manually typing the code instead of just copy pasting the code.

@YourVBTutor 7 күн бұрын

@CoderzF1 Yes I absolutely agree. There is no better way to learn than by doing.

@YourVBTutor 8 күн бұрын

Update: The automation video is live! Check it out here: kzbin.info/www/bejne/f3rchWWVdq5leNk. Learn how to save time by automating this process with VBA.

@AngelVillanueva-z8x 8 күн бұрын

That's really cooool! Thankyou for thiss!

@YourVBTutor 8 күн бұрын

Thanks for watching! 😊

@Jsnow552 8 күн бұрын

I don't believe it!

@YourVBTutor 8 күн бұрын

Believe it 😂

@temyraverdana6421 8 күн бұрын

Thanks a lot to share your knowledge. A very useful video

@YourVBTutor 8 күн бұрын

Glad you enjoyed. Thanks for watching 🙂

@valeryoni5649 9 күн бұрын

Not bad to start with.

@YourVBTutor 9 күн бұрын

Thanks for watching 🙂

@b99eu 9 күн бұрын

Thanks for this great content!

@YourVBTutor 9 күн бұрын

Glad you enjoyed. Thanks for watching 🙂

@justinhelou9603 9 күн бұрын

Would love a video tutorial on how to create the macro

@YourVBTutor 9 күн бұрын

Thanks for watching. Yes I will be releasing in a couple of days. Stay tuned! 🙂

@YourVBTutor 8 күн бұрын

I’ve just published the video automating this process! Here’s the link: kzbin.info/www/bejne/f3rchWWVdq5leNk. I hope this saves you a ton of time! Let me know your thoughts!

@temyraverdana6421 9 күн бұрын

Amazing!

@YourVBTutor 9 күн бұрын

Thanks for watching 🙂

@alexandrucoman1082 10 күн бұрын

I found the exact same code for the exact same application on Internet, nice job done with copy pasting the code and claiming that is yours and pretending to know what you are doing 😂😂

@YourVBTutor 9 күн бұрын

You're entitled to your opinion. I know that this came from my 15+ years of Excel experience, but thanks for watching anyway 🙂

@ichotw5766 10 күн бұрын

Great job! Do you have anything in mind for medical invoices, bills, benefit checks and similar stuff? Keep up the good work!

@YourVBTutor 10 күн бұрын

Yes absolutely. My series on how to integrate a database into an Excel application is a great starting point for any of these needs. Thanks for watching!

@ichotw5766 10 күн бұрын

That's great to hear! Thank you! I am exporting claims and payments data from medical software into Excel database format and it looks okay but outdated like it's Windows 98, so I would like to give it some modern touch to make it more easy to navigate etc., same goes for insurance benefit checks. Can't wait for your next video, keep it up! :)

@djmreon 11 күн бұрын

Yes make that video to automate!!

@YourVBTutor 11 күн бұрын

Thanks for watching. Yes it will be my next video to release. 🙂

@YourVBTutor 8 күн бұрын

I’ve just published the video automating this process! Here’s the link: kzbin.info/www/bejne/f3rchWWVdq5leNk. I hope this saves you a ton of time! Let me know your thoughts!

@YvesAustin 11 күн бұрын

19:20 The err.raise with vbObjectError +2 caught my attention. I’ll have to research this compared to Err.Number ;) again, great videos.

@YvesAustin 11 күн бұрын

Phenomenal series Matthew. Some prior experience with FE-BE Access db and SQL helps following along, but your explanations are very clear. I really love this Excel front-end interface and its versatility. Lots of gems along the way (class modules, dictionaries, log file, error handling, naming convention). Congrats again and thanks for sharing,

@YourVBTutor 11 күн бұрын

Thanks for the kind words and I'm glad you got value from the series. 🙂

@yvanhoe69 11 күн бұрын

Do you do contract work? Kind regards.

@YourVBTutor 11 күн бұрын

Yes I do freelance work. If you're interested please reach out: [email protected]

@YvesAustin 11 күн бұрын

This channel is going to grow very fast!

@YourVBTutor 11 күн бұрын

Thanks very much. Just trying to help the community as best as I can 🙂

@YvesAustin 11 күн бұрын

Impressive and efficient. Thanks for sharing

@YourVBTutor 11 күн бұрын

Glad you liked it!

@abdelahboulaeras6278 11 күн бұрын

Thanks Sir can you give us code vba

@YourVBTutor 11 күн бұрын

Thanks for watching. I haven't uploaded the code anywhere yet, but if you follow along with the series it will show you every line of code, step by step.

@hadibq 12 күн бұрын

Love it. Thanks. New sub indeed👍

@YourVBTutor 12 күн бұрын

Thanks for the sub! 🙂

@CoderzF1 12 күн бұрын

why not make use of Named Ranges for those settings

@YourVBTutor 12 күн бұрын

Yep, you absolutely could, and probably should, as named ranges will move with cell inserts and adjustments. In the interest of keeping it basic, I just left it as direct cell references for this video. Good pickup! Thanks for watching 🙂

@jovke79 12 күн бұрын

Hey it is great tutorial. Where did you learned this concepts in VBA ? I find difficult to find good resources.

@YourVBTutor 12 күн бұрын

KZbin has been a great source over the last couple of years, but the majority has been developing ideas out of necessity - I had a task that I needed to complete and I needed to find a way to solve it. If you have any concepts that you need advice on, then let me know and I can put it down on my list of videos to make. Thanks for watching.

@jovke79 12 күн бұрын

@@YourVBTutor My task is so complicated that its not easy to explain what exactly I need. I am seeking knowledge so I can figure it out. I said it is hard to find good resources, because on ado there is not much videos on youtube that explain well. Also your error handling is different then on other tutorials.

@YourVBTutor 12 күн бұрын

If you would like to converse a bit more about your needs then feel free to send me an email to discuss. [email protected]

@EzrielMangui 12 күн бұрын

new subscriber here! This will change the course of my dashboards! looking forward formore vids especially a step by step one <3

@YourVBTutor 12 күн бұрын

Welcome aboard! This can have a huge affect on dashboards. Glad you enjoyed. ☺️

@Dexter101x 13 күн бұрын

Interested in the automation. Great video

@YourVBTutor 13 күн бұрын

Thanks for watching. I'll be releasing a new video on the automation soon.

@YourVBTutor 8 күн бұрын

I’ve just published the video automating this process! Here’s the link: kzbin.info/www/bejne/f3rchWWVdq5leNk. I hope this saves you a ton of time! Let me know your thoughts!

@cajinguy218 13 күн бұрын

New subscriber here. Loved the video.

@YourVBTutor 13 күн бұрын

Glad you enjoyed. Thanks for the subscribe! ☺️

@Trylk1138 13 күн бұрын

Ok now without VBA??

@YourVBTutor 13 күн бұрын

The merge shapes tool doesn't require any VBA. If you're talking about the menu system, then I plan to release a video in the future on making an attractive and functional menu system without VBA. Stay tuned and thanks for watching 🙂

@toinevanderwielen9508 14 күн бұрын

This is great! Thanks for sharing. Was very helpful.😊

@YourVBTutor 14 күн бұрын

Glad it was helpful! You're very welcome 😁

@toinevanderwielen9508 22 сағат бұрын

@@YourVBTutor Found time last weekend to build it by following your video. Works flawlesly 😄

@YourVBTutor 22 сағат бұрын

Great to hear. Thanks for letting me know. Keep it up 🙂

@bobbybenj 14 күн бұрын

Interested. Nice!!!

@YourVBTutor 14 күн бұрын

Glad you enjoyed. Thanks for watching

@b99eu 14 күн бұрын

Great solution. Thanks a lot! If you could provide the macro it would even be more helpful. Thanks for your valuable work! Best

@YourVBTutor 14 күн бұрын

Thanks for the feedback! I'll be releasing a video on the automated macro soon 😀

@YourVBTutor 8 күн бұрын

I’ve just published the video automating this process! Here’s the link: kzbin.info/www/bejne/f3rchWWVdq5leNk. I hope this saves you a ton of time! Let me know your thoughts!"

@JamalHasan-o5z 15 күн бұрын

Interested. It is a well done work

@YourVBTutor 15 күн бұрын

Thank you very much! Glad you liked it 😊

@darrylbaker5271 15 күн бұрын

Very interested. i have a multi page spreadsheet and would love a home sheet with semi circle tabs, like in the end of video, to go to that sheet. Yes, interested in the VBA linking vba ppt and excel shapes

@YourVBTutor 15 күн бұрын

That's the general reason why I made the process automated in the first place, it's a great method but repetition for larger forms or sheets can be time consuming. I will release a video on this soon. Thanks for watching! 🙂

@YourVBTutor 8 күн бұрын

I’ve just published the video automating this process! Here’s the link: kzbin.info/www/bejne/f3rchWWVdq5leNk. I hope this saves you a ton of time! Let me know your thoughts!

@hrmnpsrffn 16 күн бұрын

Thank you. Yes, please make a video about that shape automaton.

@YourVBTutor 16 күн бұрын

Thanks for watching. I'll be sure to make a video about the shape automation soon. 🙂

@YourVBTutor 8 күн бұрын

I’ve just published the video automating this process! Here’s the link: kzbin.info/www/bejne/f3rchWWVdq5leNk. I hope this saves you a ton of time! Let me know your thoughts!

@Zee_Mayney 24 күн бұрын

This video was so helpful, thanks a lot Matt I feel like an excel master😁😁😁

@YourVBTutor 24 күн бұрын

Thanks for watching!

@mrnordal 26 күн бұрын

God tutorial 🙂 Is there a reason for using CreateObject and not reference to ADOX?

@YourVBTutor 26 күн бұрын

Glad to hear you enjoyed. Late binding (using CreateObject) just assures that when you distribute, it will work regardless of references set up in the target environment. Using it this way I didn't necessarily need to turn on the ActiveX reference, but it helps to understand what you're using 🙂

@azaviz Ай бұрын

Very informative 👏

@YourVBTutor Ай бұрын

Thanks very much ☺️

Ең жақсы KZbin

Пікірлер