D
donwb
Win XP, Excel 2003
Is it possible to Tab the insertion point for text in a cell.
Say I want to type "Someword" then a Tab space then "Anotherword."
Using the Tab key alone or with combinations of Shift, Ctrl and Alt doesn't
do it.
Strangely though, Alt + RETURN will move the insertion point to the next
line.
If it is not possible with keyboard strokes, can it be done
programmatically?
I have got as far as:-
ActiveSheet.Range("A1").Select
SendKeys "{F2}", True
DoEvents
(to put the cell into the Edit mode, which it does, then)
SendKeys "{Tab}", True
DoEvents
(to tab the insertion point, but it doesn't)
Help please
Is it possible to Tab the insertion point for text in a cell.
Say I want to type "Someword" then a Tab space then "Anotherword."
Using the Tab key alone or with combinations of Shift, Ctrl and Alt doesn't
do it.
Strangely though, Alt + RETURN will move the insertion point to the next
line.
If it is not possible with keyboard strokes, can it be done
programmatically?
I have got as far as:-
ActiveSheet.Range("A1").Select
SendKeys "{F2}", True
DoEvents
(to put the cell into the Edit mode, which it does, then)
SendKeys "{Tab}", True
DoEvents
(to tab the insertion point, but it doesn't)
Help please