If you're double-clicking and getting activity, I take it you already know how to use events in worksheets. Seems to me, then, that what you want is the SelectionChange event. Your routine can check that the new Selection is the particular cell you want to behave in that way; if it is, the routine can then put you Edit mode.
At least I think it can. I've never programmed the <F2> mode into VBA, but I presume that can be done.
|