How to display active cell contents in text box

Nice, that last bit of code did it, although I changed the cell reference—I probably wasn't clear about what I was trying to do. So much to know!

Sub TextBox1_Change()
ActiveCell.Value = TextBox1.Value
End Sub

You're right, I did want to show two columns of text, but only if one of those two columns is selected. But now the whole thing works like a charm. Thanks again for your help.