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
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 .
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"