First, this Excel App looks really great and is inspiring me to use Excel like this in some of my tasks.
The code below will look for and select the row being searched for. It is only looking at the "Asset Tag" and "Serial Number" fields right now. Though, there maybe a more efficient way of handling this..
Dim i As Integer
Dim assetsearch As String
Dim listcolumn As Integer
assetsearch = "" ' clear search string
listcolumn = -1
If Not SerialTextBox1.Value = "" Then
assetsearch = SerialTextBox1.Value
listcolumn = 0
If Not AssetTextBox1.Value = "" Then
assetsearch = AssetTextBox1.Value
listcolumn = 1
If assetsearch = "" Then MsgBox "There was nothing to search for"
For i = 0 To .ListCount - 1
If .List(i, listcolumn) = assetsearch Then
.ListIndex = i