If Cell1 <>0 then Cell 2 should = text or numbers, if Cell2 has data then continue macro,

All Cells are on Sheet1

T14 is numeric 0.00

T15 is general(can be text or numbers)


So what i would like to happen is this.

Part A.
If T14 <> 0
Then T15 has to contain either letters or numbers
**Now the Macro can continue to the next step**
If T15 does not contain either letters or numbers but T14 <> 0 then message box Critical "Please Enter Data Into T15"
***Stop the macro from continuing until data is entered into T15
Part B.
If T14 = 0.00
Then T15 = nothing or " "

Now here's the other trick. This same macro has another validation that i have already figured out. Do i need to combine the
Code into one long if statement with the ending being to continue the macro?

or can i have it set up with separate if statements?

I know they will be both written inside of the macro's private sub or one large statement in the macros private sub. I just need to know which method to use once we get to that point.

The code for the first two parts is below. Regarding your final inquiry, I personally like to separate the validations into individual sections. This makes it easier for future troubleshooting, especially if somebody other than you has to look at the code later.

Please Login or Register  to view this content.

swoooo... it worked and it wasnt that difficult either. Thank you.
i kept trying to use "AND" but it was not working for me. Why the use of "TRIM"?

Trim is probably not necessary. I have just grown accustomed to using it because of the data I deal with. For your purposes, you should be able to remove it with no issues.