Make Cool Buttons for Excel! (And Professional)

Рет қаралды 51,648

Күн бұрын

How to make Professional or simply Cool Buttons for Excel! These buttons look good, function well, and allow you to combine images, 3D Models, and icons in a functional and clean manner.
Excel File: www.teachexcel.com/excel-tuto...
Excel Forum: www.teachexcel.com/talk/micro...
This tutorial shows you a simple yet powerful technique for making great looking buttons in Excel - no more grey old-fashioned buttons!
You will learn to combine custom shapes, icons, images, and 3D adjustable and animated models with your buttons and make everything clickable and attached to a macro.
This video covers simple-yet-elegant buttons and goes up to crazy-but-amazing buttons with animated shapes, including a running, chomping, T-rex!
Beware, adding large images and 3D models to your files can make the file-size massive.
Excel Courses:
- VBA/Macro Course: www.teachexcel.com/vba-course...
- Building Professional Forms: www.teachexcel.com/premium-co...
TeachExcel.com
#msexcel #howto #tutorial

Пікірлер: 42

@katiesuitor5473 Жыл бұрын

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

@nicons6713 Жыл бұрын

Thanks for the tutorial. Is it possible to add the 3D effect of the customized buttons when pressed?

@guillermomaura4447 3 жыл бұрын

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

@TeachExcel 3 жыл бұрын

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

@steve_aventura Жыл бұрын

Very useful. Well done. Thank you.

@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! :)

@excelmixture 3 жыл бұрын

Nice. You refresh the memories

@TeachExcel 3 жыл бұрын

@kathyroberts7777 3 жыл бұрын

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

@chrisbhag 3 жыл бұрын

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 3 жыл бұрын

I'm glad I could help :)

@adilsiregar4893 Жыл бұрын

What a great trick!

@The1ShyButterfly 3 жыл бұрын

Excellent, thank you 😊 😎 So kool 😎

@TeachExcel 3 жыл бұрын

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

@rololoy2 Жыл бұрын

I never knew you could this with excel 🎉

@katherinepreston4221 3 ай бұрын

Thank you

@darrylmorgan 3 жыл бұрын

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

@TeachExcel 3 жыл бұрын

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

@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 :)

@cloudedjesterOG 2 жыл бұрын

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

@tonyhewitt5888 2 жыл бұрын

I cant find the icons among my shapes, any ideas

@IvanCortinas_ES 3 жыл бұрын

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

@TeachExcel 3 жыл бұрын

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.

@alidiyazamit9701 2 жыл бұрын

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!

@Excelambda 3 жыл бұрын

Brilliant!!😀✌

@TeachExcel 3 жыл бұрын

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 3 жыл бұрын

@@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 3 жыл бұрын

hahahha)

@christopherschembri7793 3 жыл бұрын

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

@TeachExcel 3 жыл бұрын

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 3 жыл бұрын

You can pause it though, by hovering over it and clicking the big pause icon that appears.

@tahwissa Жыл бұрын

What version of excel is that ?

@Knightfire66 3 жыл бұрын

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.

@hrmnpsrffn Жыл бұрын

When you change the T-rex view angle, my jaw dropped! 😲

@iancann6184 Жыл бұрын

cool

@SPCFreed Жыл бұрын

Can I pay you for 30min of help?

@KleanthisSkoulikaris 3 жыл бұрын

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 3 жыл бұрын

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