Hi forum

I have 2 text boxes on an Excel workbook and I want to use VBA to validate the field content.

The user has to fill in at least one of these text boxes with a numeric value greater than 0. If he fills in both then that is fine.

If neither is complete then I'd like to format the text box so that it is obvious something needs to be filled in for that particular field.

Any help / code sample is greatly appreciated.

Thanks