Trying to remove the last character from some text.

[pglufkin]

I am trying to remove the last character from some text with:

Application.SendKeys "{F2}"
Application.SendKeys "{BS}"
Application.SendKeys "{Enter}"

But when I do this, it is giving me the object browser in VBE . . . can anyone help?

 

[Gary's Student]

Your code works for me.

Windows 7, Excel 2007

 

[pglufkin]

Weird, I have the same, Windows 7, Excel 2007. I am debugging and starting from my worksheet I step into it, but when I get to sendkeys F2, it somehow thinks it is in the VBE and brings up the object browser.

 

[AlphaFrog]

If you're editing text in a cell, try something like this...

With ActiveCell
    .Value = Left(.Value, Len(.Value) - 1)
End With

 

[pglufkin]

Ok, got it, thank you.

I don't think stepping into procedures while analyzing code and using sendkeys are compatible.

Would that make sendkeys an inferior programming technique? I am thinking so.