| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing text in cell
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does editing a formula cause cell to reformat to text? | Excel Discussion (Misc queries) | |||
| Editing text copied into a cell by a UserForm | Excel Programming | |||
| Why does the cell I'm editing put the text on the right side? | Excel Discussion (Misc queries) | |||
| Possible too - ADD Text While editing a cell | Excel Programming | |||
| Editing text within a cell | Excel Programming | |||
Threaded Mode
