Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I place the cursor in a specific location in a cell (i.e. in between
text) using VBA? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Swapping two word and placing them in another cell | Excel Worksheet Functions | |||
Placing Col & Row identifiers into a cell as text | Excel Worksheet Functions | |||
Placing word into a seperate cell | Excel Discussion (Misc queries) | |||
Finding a value and placing text on the cell to the right | Excel Programming | |||
Downloading image and placing in cell. | Excel Programming |