Placing Cursor in a Cell
 

How do I place the cursor in a specific location in a cell (i.e. in between
text) using VBA?

Placing Cursor in a Cell
 

Mim,
Depending exactly what you want to achieve:

Range("A1").Characters(Start:=2, Length:=2).Text = " inserted text"

or
Range("A1").Select
'Sets cursor to the end of text
SendKeys "{F2}"
'Moves the cursor to the left
For i=1 to Chars_To_Move
SendKeys "{LEFT}"
Nexy

NickHK

"Mim" wrote in message
...
How do I place the cursor in a specific location in a cell (i.e. in
between
text) using VBA?

Placing Cursor in a Cell
 

Nick,
Thanks, this is exactly what I was looking for!
MIM

"NickHK" wrote:

Mim,
Depending exactly what you want to achieve:

Range("A1").Characters(Start:=2, Length:=2).Text = " inserted text"

or
Range("A1").Select
'Sets cursor to the end of text
SendKeys "{F2}"
'Moves the cursor to the left
For i=1 to Chars_To_Move
SendKeys "{LEFT}"
Nexy

NickHK

"Mim" wrote in message
...
How do I place the cursor in a specific location in a cell (i.e. in
between
text) using VBA?