Macros and the Edit Window

[Drdave1958]

Is there a way to run a macro that leaves the cell in an editing mode? I have to enter alot of data but it all has the same prefix, specifically "Ø", which is a keystroke of Alt+0216. I recorded a macro to enter the keystroke, but then I have to hit F2 or use the mouse to put the cell into edit mode and edit in the rest of the data. I'm just trying to reduce it to as few keystrokes as possible.

Thanks, Dave

 

[Juan Pablo González]

On 2002-10-08 09:15, Drdave1958 wrote:
Is there a way to run a macro that leaves the cell in an editing mode? I have to enter alot of data but it all has the same prefix, specifically "Ø", which is a keystroke of Alt+0216. I recorded a macro to enter the keystroke, but then I have to hit F2 or use the mouse to put the cell into edit mode and edit in the rest of the data. I'm just trying to reduce it to as few keystrokes as possible.

Thanks, Dave

I'm assuming that

Application.SendKeys "{F2}"

would work

 

[Drdave1958]

Works great, Thanks Juan Pablo G.

 

[gnaga]

Hi,

Using SendKeys Statement you can write a following line<Pre>SendKeys "{F2}"</Pre>

GNaga

Sorry While checking my code before posting Juan has replied and you have accepted.
This message was edited by gnaga on 2002-10-08 10:11