ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create an action button in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/54176-how-do-i-create-action-button-excel.html)

Ian G

How do I create an action button in excel?
 
I am looking to provide my dept with an action button within an excel
spreadsheet that when pressed updates all the new data in their relevant
columns.


Gord Dibben

How do I create an action button in excel?
 
Ian

Record a macro while you are doing the updating.

From the Forms Toolbar create a button and assign the macro to the button.


Gord Dibben Excel MVP

On Mon, 7 Nov 2005 16:12:03 -0800, "Ian G"
wrote:

I am looking to provide my dept with an action button within an excel
spreadsheet that when pressed updates all the new data in their relevant
columns.




All times are GMT +1. The time now is 07:36 AM.

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