ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Buttons (https://www.excelbanter.com/excel-worksheet-functions/194852-buttons.html)

Henrique[_2_]

Buttons
 
Hello!

How do I create buttons on an Excel Sheet?


Thanks.

Henrique.

Gord Dibben

Buttons
 
Forms Toolbar..........click on the button icon and draw a button. right-click
Assign a macro

Control Toolbox Toolbar........same as above except right-click and "View Code"
to paste your code into.

What you want to do with the button will govern which type to use.

The Control Toolbox button would be more customizable.


Gord Dibben MS Excel MVP



On Mon, 14 Jul 2008 21:39:22 -0300, "Henrique" wrote:

Hello!

How do I create buttons on an Excel Sheet?


Thanks.

Henrique.



JLatham

Buttons
 
What version of Excel?

For 2003, from the [View] Excel menu, choose [Toolbars] then go with either
Control Toobox or the Forms tools. I generally prefer the Forms tools, but
each has a command button available and each has advantages/disadvantages.

If those aren't the type of buttons you want, you can also place shapes on a
worksheet and format their size, shape and color and add text to them and
then assign a Macro to run when they are clicked.

"Henrique" wrote:

Hello!

How do I create buttons on an Excel Sheet?


Thanks.

Henrique.



All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com