• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA IF not Working

hi all,

i have facing problem with below code

Code:
            If Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, ThisWorkbook.Worksheets("IT").Range("B5:Y105"), 9, False) = "0" Then
                Range("M16:O16") = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, ThisWorkbook.Worksheets("IT").Range("B5:Y105"), 10, False)
            End If


when i m run, value is blank :(

thank's in advance :)
 
Back
Top