Value from Textbox on Userform to Cell on Sheet

[MichelVBA]

I have build a userform with 3 tabs (see fig.2). On the whole userform are several textboxes that's connected with cells on a sheet (see fig.1)
In specialy one textbox (see fig. 3), the value will not not save to the sheet. Fig.3 in the next post.
The properties of the textbox is the setting "MultiLine" on True.
I am an newbe with VBA, and im sure i meshed up with the code and the file is so large that the code reaches to Rome.

 

[MichelVBA]

this is post 3 with fig.3

 

[MichelVBA]

This was my insperation to do what i have done sofar.
TheDataLabs

 

[MichelVBA]

I found the problem. The cells are blocked when the code below is activated.
This means that the value cannot be copied or modified and saved.
Does anyone know a code that undoes the selection once the userform has loaded.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A2:IA1000")) Is Nothing Then
If Target.Address = Target.EntireRow.Address Then
frmForm9.txtProjnr = Cells(Target.Row, 2)
frmForm9.Show
End If
End If
End Sub

 

[Sam_D_Ben]

Recalled

 

[Teeroy]

If your userform is modal then use Application.EnableEvents=False in the UserForm_Activate code and Application.EnableEvents=False in the UserForm_Deactivate code.
This will prevent event driven code from running while you are entering the date in the the userform and transferring it to the sheet.

 

[MichelVBA]

Ok thanks, but this is beyond my capabilities. Unfortunately I have too little knowledge of VBA to understand this right away.
Userform_Activate code??
My userform starts as soon as a line number is selected.
Or, after this problem arose, via a separate button.

 

[Teeroy]

In the VBA Project Explorer you'll find similar to the image which will help with where you'd put the code.

 

[MichelVBA]

Dear @Teeroy
Somehow this doesn't work for me.
The selected line remains active after the userform appears, which means the changes are not saved.