Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
updating cells when one is typed into | Excel Discussion (Misc queries) | |||
How can I protect cells w/formulas from being typed over? | Excel Discussion (Misc queries) | |||
Can numbers be typed to automatically be negative in cells? | New Users to Excel | |||
How do I apply a formula to #s already typed in a series of cells | Excel Worksheet Functions | |||
can I turn off the memory carry-over from previously typed cells | Excel Worksheet Functions |