I'm trying to make a form for my work and part of it is a roster of who is involved on project. I'm trying to make the form really slick but I ran into a little roadblock and I'm not sure if there's a workaround.
Here's what I want:
# Name Position 1 John Smith Sales Add New Team Member...
I want the user to be able to edit the "Add New Team Member" cell and as soon as they do, the cell clears so that it's blank when they start typing a name. Later, after the user enters a name, I want to make the next row say "Add New Team Member", but that's an easy task with a regular old change event. It's the clearing action prior to the user adding a name that I need help with.
The closest I've gotten is using a BeforeDoubleClick change event, but this limits the code to run only on a Double-click event. I also need Excel to capture the F2 edit method as well as the typical "SelectCell/JustType" method of cell editing too. Unfortunately it doesn't look like there's a BeforeCellEdit change event so I need a workaround.
If I can't find a workaround, I may just have to settle for a Selection Change event but I'd be a little disappointed.
Any ideas?
Bookmarks