How to Move or Place a Command Button onto the Ribbon

[KenWit]

I'm making a Userform for commands I use a lot, like concatenation and highlighting cells. I placed a command button on the sheet that pops up whenever I open Excel. It's a bit awkward to have it on the sheet. Is there a way to place the button on the ribbon to get it out of the way? (I'm on an intermediary level with VBA, so I'm still not entirely sure what I'm doing ) Thanks!

Another alternative would be to make a hide button on the userform, I guess. Once it disappears though I'd probably need another button to call it up again.

 

[AlphaFrog]

Here's a good step-by-step tutorial...
Change the Ribbon in Excel 2007 or Excel 2010

You can find several others by doing a web search for something like Excel customize the ribbon.

 

[KenWit]

Thanks AlphaFrog!
(I was trying web searches like "move command button to ribbon" and getting nowhere fast.) The linked page looks promising.

 

[KenWit]

My mistake. I was looking to add the command button to the quick access toolbar at the top of the screen. Is there a way to do that?

(Customizing the ribbon is wild. I'll definitely consider that for the future. Looks a bit too complicated for me to try now.)

 

[AlphaFrog]

Same link. Scroll down to section 12.

 

[KenWit]

That looks like what I need. Not as complicated either. Thanks
Will let you know how it works out.