Nigel Martin
Board Regular
- Joined
- Feb 17, 2002
- Messages
- 133
In column 'C' of my spreadsheet I have comments from variuos people which must be quoted in full upwards of 1000 charaters. I have inserted a UserForm with a TextBox on it with its source pointing at the first of my list in column 'C' (ie source box =C3). What code do I need so that when the user uses an arrow (direction) key to go down or up to the next cell, the UserForm refreshes with the appropriate cell reference from column 'C' ?