Hi There,
Long-time lurker. First-time poster. I have just build some VBA code by poking around on this and other forums. The code essentially works, except it seems to freeze my ability to input more than one character in any cell within the Target.Column of the function. The goal of the code is as follows:
- Whenever a value is entered or deleted in a cell within Column CF (84), the function should run.
- It should place the current date/time in column CG (85)
- It should find the next empty column in the current row and place the Column CF value (if there is one) or the string "DONE at" followed by the current date/time.
My current code is sitting in the VBA object of the sheet in question and looks like this:
As I said, it is sort of working as planned, but is messing up text input in that column. I enter one character and the cursor just blinks without accepting any more input. It doesn't even listen to enter. I have to click with my mouse outside of the column, then the function executes as I would expect it to and the other columns fill up.Please Login or Register to view this content.
What am I doing wrong? How can I get this same thing accomplished without messing up my ability to input text? Thanks!
Bookmarks