blanket "if null" statement

[synergy16]

good morning all. after a bunch of calculations i narrow down a single row based on user choice and populate textboxes with related data. some of the cells are blank tho. is there a way to, perhaps with a loop, to tell the program if any of those cell locations are null to put a "N/A" in the textbox or do i have to a if/then statement for each one?

 serialNumTB = Cells(stripPartRow, 7)    partQtyTB = Cells(stripPartRow, 5)
    partRevTB = Cells(stripPartRow, 4)
    lotBatchTB = Cells(stripPartRow, 6)
    jobProOrderTB = Cells(stripPartRow, 8)
    supplierTB = Cells(stripPartRow, 9)
    shipOutDateTB = Cells(stripPartRow, 10)
    origPoDate = Cells(stripPartRow, 11)
    expDockDateTB = Cells(stripPartRow, 12)
    customerTB = Cells(stripPartRow, 2)
    relatedPrtTB = Cells(stripPartRow, 13)
    notesTB = Cells(stripPartRow, 14)

 

[Fluff]

If the textboxes are on a userform try

   Dim Ary As Variant
   Dim i As Long
   
   Ary = Array("serialNumTB", 7, "partQtyTB", 5, "partRevTB", 4)
   For i = 0 To UBound(Ary) Step 2
      If Cells(stripPartRow, Ary(i + 1)) = "" Then
         Me.Controls(Ary(i)) = "N/A"
      Else
         Me.Controls(Ary(i)) = Cells(stripPartRow, Ary(i + 1))
      End If
   Next i