I have vba user form with text box a button and a list box. i require only the value of the last text box "Name" to the last column of selected row of list box.I already write a code in the add button and all the code is working but the last line of code is not working.The code and file is give.
Code
Private Sub cmdBtn1_Click()
Dim findvalue As Range
Dim DataSh As Worksheet
Application.ScreenUpdating = False
Set DataSh = ThisWorkbook.Worksheets("Cheq Issued")
Set findvalue = DataSh.Range("H:H").Find(what:=T4.Value, LookIn:=xlValues, Lookat:=xlWhole)
findvalue = T4.Value
findvalue.Offset(0, -3) = T2.Value
findvalue.Offset(0, 1) = T5.Value 'Help Require only for this line of Code
Application.ScreenUpdating = True
End Sub
Display More