Make Cool Buttons for Excel! (And Professional)

[@chrishellmax]

I love it. Every time i do excel (my fav program in the world) i learn something new. Thank you.

[@TeachExcel]

You're very welcome Chris! :)

[@katiesuitor5473]

Your clarity is fantastic! And your sense of humor is refreshing. Thank you for making learning fun.

[@kathyroberts7777]

Love this, I would get into a lot of trouble if I did this at work!

[@m.furrier9141]

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"

[@TeachExcel]

This part of the 3D models brings me too much joy I must say :)

[@chrisbhag]

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 😊

[@TeachExcel]

I'm glad I could help :)

[@guillermomaura4447]

Excellent ideas to make very cool buttons in Excel. Thanks a lot !!!

[@TeachExcel]

You're welcome Guillermo! I'm glad you think so!)

[@excelmixture]

Nice. You refresh the memories

[@TeachExcel]

:)

[@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! 😲

[@The1ShyButterfly]

Excellent, thank you 😊 😎 So kool 😎

[@TeachExcel]

You're very welcome! I'm glad you like it)

[@darrylmorgan]

LOL Super Cool Bit Of Fun...Thank You Sir :)

[@TeachExcel]

You're very welcome! I had way too much fun with this video when I found the Dino hahaha

[@katherinepreston4221]

Thank you

[@IvanCortinas_ES]

Very Cool!! The only problem is that the icons take up a lot of storage space. Thank you very much.

[@TeachExcel]

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.

[@tonyhewitt5888]

I cant find the icons among my shapes, any ideas

[@Excelambda]

Brilliant!!😀✌

[@TeachExcel]

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

[@Excelambda]

@@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 😂😂

[@TeachExcel]

hahahha)

[@alidiyazamit9701]

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!

[@cloudedjesterOG]

Can you remove the play and pause button so it isn’t there ?

[@Knightfire66]

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?

[@chrishellmax]

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

[@christopherschembri7793]

Thanks for the video. Is there an option to animate the icon only when it is clicked?

[@TeachExcel]

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.

[@TeachExcel]

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?

[@KleanthisSkoulikaris]

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....”

[@TeachExcel]

Bahahahaha this is killing me! :))))) (somehow this got caught in youtube's spam filter, but I'm glad I found it)

[@aeryncoble4811]

A lot of assumptions and pre-work to follow along making this less useful than advertised.