Hi, struggling a bit with the below code.

The VLOOKUP bit works fine. The issue I have is if I delete the contents of "C15", The previous VLOOKUP result remains as a caption instead of renaming the caption to "Blank"

ActiveSheet.CommandButton24.Caption = Application.WorksheetFunction. _
        VLookup(Range("C15").Text, Worksheets("Vendor List").Range("B2:J2000"), 9, False)
    If Range("C15").Value = "" Then ActiveSheet.CommandButton24.Caption = "Blank"
Any help would be greatly appreciated.

MTIA