How to keep an cell active for editing.

How does one have a macro add text and then stay "alive" for further text input?

For example, if I had a button that placed the prefix "Inventory - " in a cell so that the product could be typed in afterwards to avoid having to type "Inventory - " out so many times when it's only the product changing.

I've got this much so far.

ActiveCell.Value = "Inventory - "
ActriveCell.Select

Unfortunately it still requires an F2 press before I can start typing again or else it will write over the existing text.

Thanks in advance.

You would have to popup an Application.InputBox asking for the text to enter, then put it all into the cell at once.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.