vba code to select cell & put in edit mode

[Peter_SSs]

In vba code, I would like to be able to select a cell and put it in 'edit mode'. That is, I want to be able to do the equivalent (after selecting the cell) of the following keystrokes:

F2
Home
Shift + End

Any help appreciated.

Peter

 

[Tom Urtis]

Sub Test1()
Range("A1").Select
SendKeys "{F2}"
End Sub

 

[Nimrod]

Sub Macro7()
Application.SendKeys "{F2}"
Application.SendKeys "{HOME}"
Application.SendKeys "+{END}"

End Sub

 

[Tazguy37]

Why not all at the same time?:

Public Sub test3()
    Application.SendKeys ("{F2}{HOME}+{END}")
End Sub

 

[Peter_SSs]

Thank you all for your help - it was exactly what I needed.

Peter

 

[bmarroush]

Hi Tazguy

If i want to use the same code for a range of cells at one time not only cell by cell

for example

Public Sub test3()
Range("A3:A6").Select
Application.SendKeys ("{F2}{HOME}+{END}")
End Sub


Is it possible ? cuz when am applying this it is stucked only at the A3 and it is not going to other cells at one time

Thanks in advance

 

[Mrvette134]

Sub Test1()
Range("A1").Select
SendKeys "{F2}"
End Sub

How can I have a box pop up asking me for which cell, edit the contents, then save?

 

[SpillerBD]

Why not just enter the desired cell in the name box?
Then the above macro, Enter.

 

[Mrvette134]

my bad for not being specific. You are correct that would work. This is sheet will be used by non-Excel users. Sheet1 (Menu), Sheet2 (data), I'm thinking of using a Dropdown list to select users from Sheet2, then click a button to pull up User's name and with options to Edit that name, then save and close.