thanks for your extensive Excel-knowledge-sharing - I used to be a graphic designer, but now I'm in data. Pretty interfaces was always a dream for me with Excel - you just changed all of that as of right now! TY! TY! THANK YOU!
Excel really has so much more potential than many people realise. And that absolutely extends to its possibilities with graphic design. Glad you enjoyed the content. Thanks 🙂
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!
Sir i have made tic tac toe & snake game with amazing animations, i think i am expert, but you are amazing, keep up the good work and amazing advance level of vba coding. Please continue videos like making beautiful Userform, like your recent uploaded video... ❤❤
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
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.
@@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.
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. yourvbtutor@outlook.com
FYI - I ran the code and it worked... then ran the code again and got the same error - Quit Excel and tried again and it now worked... so it's probably a glitch in VBA. the error did not happen again yet
thanks for your extensive Excel-knowledge-sharing - I used to be a graphic designer, but now I'm in data. Pretty interfaces was always a dream for me with Excel - you just changed all of that as of right now! TY! TY! THANK YOU!
Excel really has so much more potential than many people realise. And that absolutely extends to its possibilities with graphic design. Glad you enjoyed the content. Thanks 🙂
Thank you, sir!
Thanks for watching 🙂
That's really cooool! Thankyou for thiss!
Thanks for watching! 😊
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!
Great to hear! Logging is a fantastic tool for professional app building. Well done! Thanks for watching 🙂
Sir i have made tic tac toe & snake game with amazing animations, i think i am expert, but you are amazing, keep up the good work and amazing advance level of vba coding. Please continue videos like making beautiful Userform, like your recent uploaded video... ❤❤
Sounds like a great project, well done. Thanks very much for watching 🙂
Great! That is really cool! Thank u very much!😊
Glad you enjoyed! Thanks for watching.
👏👏👏👏Excellent! A little too fast for my ability. Any chance of getting the code?
Thanks for watching. Glad you enjoyed. Feel free to pause throughout the video to give yourself a chance to copy the code. 😊
@@YourVBTutor i agree with this statement. you learn the code better by manually typing the code instead of just copy pasting the code.
@CoderzF1 Yes I absolutely agree. There is no better way to learn than by doing.
It would be great if you give us the file
I always believe it's better to follow along to give you the best chance of learning the techniques. But thank you for watching and commenting 🙂
❤❤❤
Thanks for watching 😊
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
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.
@@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.
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. yourvbtutor@outlook.com
FYI - I ran the code and it worked... then ran the code again and got the same error - Quit Excel and tried again and it now worked... so it's probably a glitch in VBA. the error did not happen again yet