inserting vbLf (line feed)
Posted by Robert Simms on October 19, 2001 6:09 AM
A friend has a lap top computer with no numeric keypad "Enter" key. This seems to make it impossible to force line breaks with Alt+Enter (which will enable user-controled line breaks in line wrapping formatted cells).
Excel provides a sample of what might be done... under Toolbars/Customize/Commands in the "Insert" category there are buttons/commands to insert single characters. These work in or out of formula bar editing mode.
I tried recording a macro wherein I entered a line break in a cell. The macro just sets the value of the cell to a string, using string concatenation and the "vbLf" constant.
So, the question is: with a macro, can anyone find out how to mimic the user typing any key or key combination, in or out of formula bar editing mode? Or how to paste a character at the cursor position in the formula bar.