TextBox.

[Nigel Martin]

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' ?

 

[Ivan F Moala]

On 2002-04-15 00:06, Nigel Martin wrote:
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' ?

Hi Nigel you could use the worksheets change
event to update the userorms checkbox eg
In the relevant sheet

<pre/>
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 3 And UserForm1.Visible = True Then
UserForm1.TextBox1.Text = Target.Text
End If
End Sub
</pre>
Note, I'm assuming your UFrm is showmodal=false
and you are selecting the cells via key input change by the user.