insert cursor

[y481184]

I have two cells that I am trying to manipulate. The first cell is blank and this is where the user inserts a numerical unit e.g 10. I want the cell directly after this one to default to "lbs of." I accomplished this by simply including this in Range("G37").Value = "lbs of"
My quation is how to go about making the cell active and place the cursor in cell G37 directly after "lbs of." I know this can be accomplished by pressing F2, but I would like it to activate and accept text automatically without overwriting the default value in the cell.

 

[Andrew Poulsom]

This worked for me:

Sub Test()
Range("G37").Value = "lbs of "
Range("G37").Activate
SendKeys "{F2}"
End Sub

The sheet must be active and the SendKeys statement must be the last in you code.