Check that something was actually found...
![]()
Set c = Sheets("Customers").Columns(2).Find(FindMe, LookIn:=xlValues) If Not c in Nothing then Me.TextBox1.Value = c.Offset(0, 1).Value Else '// Some kind of error message End If
Check that something was actually found...
![]()
Set c = Sheets("Customers").Columns(2).Find(FindMe, LookIn:=xlValues) If Not c in Nothing then Me.TextBox1.Value = c.Offset(0, 1).Value Else '// Some kind of error message End If
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks