Hi,
I have a following code in my workbook
i want to add vbyesno code with

If rngFound Is Nothing Then
MsgBox "ID not Found, Want to Create?" vbyesno



PHP Code: 
Private Sub cmdfndnext_Click()
    
Dim strPrefix As StringstrSuffix As StringstrID As String
    Dim rngFound 
As Rangerngstart As Range
    Dim i 
As Long
    
    strID 
Trim(txtid.Text)
    
    If 
cmdfndnext.Tag "Next" Then
        Rem incriment ID number
        
For Len(strIDTo 1 Step -1
            
If Mid(strIDi1Like "[!0-9]" Then
                strPrefix 
Left(strIDi)
                
strSuffix Mid(strID1)
                If 
Len(strIDThen
                    strSuffix 
Format(Val(strSuffix) + 1String(Len(strSuffix), "0"))
                
End If
               Exit For
            
End If
        
Next i
        strID 
strPrefix strSuffix
        txtid
.Text strID
        
    End 
If
    
    
With Sheets("Life Member").Range("A:A")
        
On Error Resume Next
        Set rngFound 
= .Find(txtid.TextAfter:=.Cells(Rows.Count1), Lookat:=xlWholeLookIn:=xlValuesMatchCase:=True)
        
On Error GoTo 0
    End With
    
    
If rngFound Is Nothing Then
        MsgBox 
"ID not Found"
        
    
Else
        
With rngFound.EntireRow
                        
            txtname
.Text = .Cells(12).Text
            txtremark
.Text = .Cells(13).Text
            txtstatus
.Text = .Cells(14).Text
            txtreceipt
.Text = .Cells(15).Text
            txtyear
.Text = .Cells(16).Text
            

        End With
    End 
If
    
    
cmdfndnext.Tag "Next"
End Sub