Does TextBoxHN1 return a true/false result or do you mean
to say if TextBoxHN1 < "" then do Cells(NextRow, 2).value =
TextBoxHN1.value & TextBoxHN2.value & TextBoxHN3.value
and again on the next line.

What is the runtime error type?


---
Message posted from http://www.ExcelForum.com/