insert ( ) in active cell : VBA

[bamaisgreat]

Thanks for looking at my post.. What I am trying to achive is when a cell is selected (no paticular cell) you could hit a button and theis would be inserted after what is already in the cell and the cursor would be blinking in between them..
I no this a bit odd.....

 

[Andrew Poulsom]

Try:

Sub Test()
    With ActiveCell
        .Value = .Value & "()"
    End With
    SendKeys "{F2}{LEFT}"
End Sub

 

[bamaisgreat]

Andrew, when i enter for Example: if there is F534 in cell J9, when I select it and run the macro it selects J9 and back to A9 and the cursor is not between the brackets.. It does add the brackets at the end of the text thats there the cursor is just not blinking in between them

 

[Andrew Poulsom]

It works for me in Excel 2003.

 

[bamaisgreat]

Thanks it worked