Patriot2879
Well-known Member
- Joined
- Feb 1, 2018
- Messages
- 1,259
- Office Version
- 2010
- Platform
- Windows
hi i have a code below that when i enter a number in TextBox11 it will find the data automatically to enter in the MPANBox, but it keeps coming up with an error please can you help me on this? many thanks.
Code:
Private Sub TextBox11_AfterUpdate()
Dim Fnd As Range
Set Fnd = Sheets("Export ETA").Range("A:A").Find(TextBox1.Value, , , xlWhole, , , False, , False)
If Not Fnd Is Nothing Then
MPANBox.Value = Fnd.Offset(, 2).Value
End If
End Sub