Dear All,

I'm new at Excel-programming!

I want to show a form to input several lines of text in a cell.
I can NOT enlarge the cell.
I created a userform that shows when the cell has the focus.
BUT how do i take the value from the cell to the form-controle and back.
When opening the formcontrole must show the cell-value.
Closing the form the cell must show the form-controle-value.


Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
If Target.Column = 9 And Target.Row 6 Then
Frm_NOTA.Show
ActiveCell.Value = ........?????
End If
End Sub

Thanks,

Filip