Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
R D S
 
Posts: n/a
Default enter data in cell then run macro automatically

Hi,

Is it possible that I can enter data into a cell and then the pressing of
the enter key will cause a macro to run?

Rick


  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Yes.

That type of macro is run from Event code.

For more on events see Chip Pearson's site at

http://www.cpearson.com/excel/events.htm

Or David McRitchie's site at

http://www.mvps.org/dmcritchie/excel/event.htm


Gord Dibben Excel MVP

On Tue, 25 Jan 2005 21:04:42 -0000, "R D S" wrote:

Hi,

Is it possible that I can enter data into a cell and then the pressing of
the enter key will cause a macro to run?

Rick


  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Yes..

http://www.cpearson.com/excel/events.htm


http://www.mvps.org/dmcritchie/excel/event.htm


Regards,

Peo Sjoblom

"R D S" wrote:

Hi,

Is it possible that I can enter data into a cell and then the pressing of
the enter key will cause a macro to run?

Rick



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
Enter TODAY if cell has data Cie New Users to Excel 6 December 21st 05 04:18 PM
Excel: How do I enter a date in one cell & automatically dates adj Shannon Excel Discussion (Misc queries) 4 January 12th 05 12:51 AM
Enter Data Into Another Excel File Automatically Morrisg Excel Worksheet Functions 0 January 11th 05 02:07 AM
I need a macro to find cut and paste data to new cell Rex Excel Discussion (Misc queries) 0 December 6th 04 12:45 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 07:19 PM.

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

About Us

"It's about Microsoft Excel"