VBA for edit mode

What is the VBA to select a cell in the Edit mode.

For example same as Selecting cell A1 then F2.

Thanks a lot. mikeburg

Do you mean the equivalent of selecting "A1" and pressing [F2]? If this is so you may want to check the InStr or Left/Right functions.

Thank you for the reply.

I am wanting to put VBA at the end of a procedure I have ran that effectively goes into the edit mode (F2) of a text string that already exists in cell A3. For example, I may have in cell A3, a text string like below that I am editing the last word to a different word:

In cell A3:
"Put something into the inventory of Automotive"

to

"Put something into the inventory of Appliances"

without having to retype the whole string.

Now I select A3 and hit the F2, delete the characters or word & type the new characters or word.

I realize only one keystroke will be saved (F2), but if I had the VBA that goes into the edit mode, I can use it in a lot of other editing we do.

Thanks for all your help. mikeburg