I love it. Every time i do excel (my fav program in the world) i learn something new. Thank you.
@TeachExcel2 жыл бұрын
You're very welcome Chris! :)
@katiesuitor5473 Жыл бұрын
Your clarity is fantastic! And your sense of humor is refreshing. Thank you for making learning fun.
@kathyroberts77773 жыл бұрын
Love this, I would get into a lot of trouble if I did this at work!
@m.furrier91412 жыл бұрын
note: animated 3d-models also have different scenes (animation reels) click on the 3d-model (therefore go to tab 3d-model), in the top left corner of the screen you have the pause/play button an right next to it "scenes"
@TeachExcel2 жыл бұрын
This part of the 3D models brings me too much joy I must say :)
@chrisbhag3 жыл бұрын
I learned how to do this before but I was trying to do this last weekend and found I forgot. Thanks for this, it’s really awesome 😊
@TeachExcel3 жыл бұрын
I'm glad I could help :)
@guillermomaura44473 жыл бұрын
Excellent ideas to make very cool buttons in Excel. Thanks a lot !!!
@TeachExcel3 жыл бұрын
You're welcome Guillermo! I'm glad you think so!)
@excelmixture3 жыл бұрын
Nice. You refresh the memories
@TeachExcel3 жыл бұрын
:)
@rololoy2 Жыл бұрын
I never knew you could this with excel 🎉
@steve_aventura Жыл бұрын
Very useful. Well done. Thank you.
@nicons6713 Жыл бұрын
Thanks for the tutorial. Is it possible to add the 3D effect of the customized buttons when pressed?
@adilsiregar4893 Жыл бұрын
What a great trick!
@hrmnpsrffn Жыл бұрын
When you change the T-rex view angle, my jaw dropped! 😲
@The1ShyButterfly3 жыл бұрын
Excellent, thank you 😊 😎 So kool 😎
@TeachExcel3 жыл бұрын
You're very welcome! I'm glad you like it)
@darrylmorgan3 жыл бұрын
LOL Super Cool Bit Of Fun...Thank You Sir :)
@TeachExcel3 жыл бұрын
You're very welcome! I had way too much fun with this video when I found the Dino hahaha
@katherinepreston42214 ай бұрын
Thank you
@IvanCortinas_ES3 жыл бұрын
Very Cool!! The only problem is that the icons take up a lot of storage space. Thank you very much.
@TeachExcel3 жыл бұрын
Yesss that is the sad thing, but I did notice that you can repeat the same 3d model multiple times and it won't change the size of the file after the addition of the first one, at least in my tests. But I think the sample file for this tutorial is 40mb with the dino lol.
@tonyhewitt58882 жыл бұрын
I cant find the icons among my shapes, any ideas
@Excelambda3 жыл бұрын
Brilliant!!😀✌
@TeachExcel3 жыл бұрын
haha glad you like it :) If it didn't make files so big, I'd try to sneak the dino into more files to lighten things up lol
@Excelambda3 жыл бұрын
@@TeachExcel You made my day , did not test the trick before, at least not the animated ones. Now I am playing like a 5 years old child. 😂😂✌✌ . So cooooool . I will not thank you for that 😂😂
@TeachExcel3 жыл бұрын
hahahha)
@alidiyazamit97012 жыл бұрын
And when do we need to creat buttons? Sorry, I only use regular formulas & pivots. And can’t understand where I could use buttons, because now I crazily want to try it!
@cloudedjesterOG2 жыл бұрын
Can you remove the play and pause button so it isn’t there ?
@Knightfire663 жыл бұрын
yeah but you can only assign a macro to those custom macro btns. there are no events like onhover or onchange... so how to customize the activex btns to look like that?
@chrishellmax2 жыл бұрын
Use active x control buttons, then you have a lot more wiggle room and you can also add vba code to it.
@tahwissa Жыл бұрын
What version of excel is that ?
@iancann6184 Жыл бұрын
cool
@christopherschembri77933 жыл бұрын
Thanks for the video. Is there an option to animate the icon only when it is clicked?
@TeachExcel3 жыл бұрын
I just checked it out a little and it looks like it would be under ShapeRange.Model3D in VBA and that seems to only control the view of it, not if it is moving. Maybe there in another way to do it, but I'm not sure at the moment.
@TeachExcel3 жыл бұрын
You can pause it though, by hovering over it and clicking the big pause icon that appears.
@SPCFreed Жыл бұрын
Can I pay you for 30min of help?
@KleanthisSkoulikaris3 жыл бұрын
Soon on News networks around the world: “We’ve been receiving multiple reports from various Excel users about a novel “Jurassic virus” infecting their spreadsheets while at the same time improving their work efficiency. Stay with us for further reports....”
@TeachExcel3 жыл бұрын
Bahahahaha this is killing me! :))))) (somehow this got caught in youtube's spam filter, but I'm glad I found it)
@aeryncoble48112 ай бұрын
A lot of assumptions and pre-work to follow along making this less useful than advertised.