Help Please

I have a spreadsheet with some macros running, one of which is a user form which you input data (e.g. 5.6). This data is then transferred to sheet1 (I15). when this is done a formula in (J15) calculates weather (I15 e.g. 5.6) is within a range (C15 e.g. 5.4) and (E15 e.g. 5.8) and returns a value of "pass" or "fail" The formula I have written is =IF(AND(I15>=C15,I15<=E15),"pass","fail". My problem is that it keeps returning a "pass". Is there a format problem between the macro returning the value to the sheet ?

 

Thanx in advance

String to Array

Hello, I have a cell in my spreadsheet that contains the following content...

'Name1, Name2, Name3, Name4, Name5'

I would like to convert this list of comma separated items into an array in VBA and vice-verse.
Is there any way to do this in VBA code?

Thank you,
David

Split

Use the Split function

Vishesh's picture

Help for Pass Fail

1. Try Value for comparison like =IF(AND(value(I15)>=value(C15),value(I15)<=value(E15)),"pass","fail")

2. Check if Calculation is set to automatic, or sheet's enable calculation is true.

3. Check cells' format

help please

Thank you for the reply.

What i'm trying to say is that when I have inputted the figure into the textbox in the user form, it transfers it to sheet1 as text. What I want to do is when this is transferred it transfers it as a number, not as text .

 

 

JPH's picture

which command for filling cells

with which command do you put the "text" into the cells?

try using Range("A1").value = text

make sure the cell format is "general" or "number"