IsNumeric Help

Hi all,

I am having trouble with the following code. What I would like to happen is... if 'YieldLossCost' is a valid number (sometimes the intersection may return a non number), I want it to display "There is no data relating to this melt route and stage. Either it is not relevant or is missing." If there is no value inputted into 'YieldLossWeightText', I would like it to display "Please enter a yield loss weight!". Only if both conditions are met would I like the calculation to performed and the value entered into C6... Any ideas?

Please Login or Register  to view this content.

Thanks in advance.

Is the code not working?

Perhaps you could rearrange it a bit.

Please Login or Register  to view this content.

Hi Norie,

You are a life saver today! The two texts were the wrong way round in your code but I swapped them and got the result that I wanted.

I used vbNullString as I found the formula I used on another website and it was in that. I don't really understand the usage of it. I guess I could take it out?

No leave it in, it makes sure that a blank cell isn't treated as numeric.

I've actually seen if before but not in Access rather thant Excel.

Originally Posted by Norie

No leave it in, it makes sure that a blank cell isn't treated as numeric.

I've actually seen if before but not in Access rather thant Excel.

Ok great. That's what I want. Will mark as solved.