LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Intercepting data typed into cells.

I have about 50 scattered cells on my spreadsheet that are
"special". If a user types data into any of these cells, I would
like to immediately check what they typed, modify it how I want,
and then enter the new data into the cell.

For example, suppose a user types "eggs" into cell A1.
I want to change this to "green eggs" immediately after
they type "eggs" in cell A1 and press the Enter key.

I know that this will require me to use the "Worksheet_Change()"
event or subroutine. Is this the only way to handle changes to
the spreadsheet?

I guess I'm just worried about performance. To me it
doesn't make sense to check when ANY cell is changed. It
would be great if I could limit Worksheet_Change() to
only be activated when one of my 50 cells is changed.
Is this possible?



 
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
updating cells when one is typed into Mike W Excel Discussion (Misc queries) 3 August 22nd 09 04:56 PM
How can I protect cells w/formulas from being typed over? lucifuge Excel Discussion (Misc queries) 3 August 10th 06 12:00 AM
Can numbers be typed to automatically be negative in cells? finnplan New Users to Excel 1 December 8th 05 10:25 PM
How do I apply a formula to #s already typed in a series of cells redinBR Excel Worksheet Functions 1 May 18th 05 11:09 PM
can I turn off the memory carry-over from previously typed cells Mpski5 Excel Worksheet Functions 8 May 17th 05 07:35 PM


All times are GMT +1. The time now is 02:53 AM.

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"