Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking if text changed?
Hello,
In order to streamline the filling out of a certain worksheet, I want to set it up so when you change a given cell and press enter or any other command to leave it, you get whisked right into the next cell you need to fill out, rather than having to move through a bunch of "buffer" cells (cells you dont fill out, that just identify what things are...) I am able to check which cell they were previously in by putting a "Dim prevcell As Range" at the top, setting this to Target as they move around, and running if's on it to check what the previous cell was when Worksheet_Changeselection is run. I only want to whisk the activecell around if they actually CHANGED text though-- dont want the thing to jump all over when theyre just trying to manually move through with arrow keys... The problem is, I can't get a similar strategy to work with a "prevtext". I do a Dim prevtext As String, then set it to target.formulaR1C1 as they move around -- no luck. "Type mismatch". What would be the proper method to do something of this nature? Thanks very much in advance, very much appreciated. SA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement checking if a cell's text is red | Excel Worksheet Functions | |||
My text was changed to red... | New Users to Excel | |||
Text not fully displayed when text direction changed | Excel Discussion (Misc queries) | |||
Checking for dublication of text | Excel Worksheet Functions | |||
Spell checking text boxes | Excel Programming |