using VB for Excel

hi all

basically i have added a form to input information into a worksheet.

I'm trying to make add so that when i click the "OK" command button, I have on my form, it will add the info to the last row in the spreadsheet that does not contain text.

basically I'm not sure how to create an IF statement that will test to see if a cell contains text.

so heres the logic:

IF sell contains text go to the next cell

thanks

I apologise if some1 has already asked this question, but after a quick scan i cant see anything relating to what I need to know

Brian