VBA Project Question – IS 201 Discussion Forum

Questions Archive › Category: Questions › VBA Project Question

Maya Jones asked 3 years ago

I have completed the VBA Project, but one thing is wrong when I run my programs. I put into the code “NS =1 And NL = 1”, but for some reason, in that number of people data range (61-85), they both turn out as zero, but all my other statements work. Can two variables not be the same number? If so, how to do code it so both of those variables can be equal to one?

1 Answers

1 Vote Up Vote Down

Shayna answered 3 years ago

NS = 1 And NL = 1 is actually a condition and doesn’t actually process anything. Basically what you’re saying is, “When NS = 1 and NL = 1,” and the program will do just that. You have to tell it “NS = 1” , “NL = 1” on separate lines.

Your Answer