Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ian G
 
Posts: n/a
Default 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.

  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I create a button in Excel that generates a task in Outlook? Tio777 Excel Discussion (Misc queries) 1 June 15th 05 03:41 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel shoud not close all active books when clicking close button technomike Excel Discussion (Misc queries) 0 June 10th 05 05:35 PM
Macro to simply bring up the Find dialogue box?? marika1981 Excel Discussion (Misc queries) 14 January 14th 05 10:47 PM
How do I setup a spin button in excel Andy K Excel Discussion (Misc queries) 1 November 26th 04 09:08 PM


All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"