If-Then VBA

seventy9mph · April 21st, 2009, 02:16 PM

I am a very beginner VBA user

If A1 is greater than or equal to B1, automatically put the value of A5 in C1 and then allow user input into cell C2 via perhaps a popup box or something similar

If A1 is less than B1, automatically put the value of A6 in C2 and then allow user input into C1 via perhaps a popup box or something similar

A1 and B1 will be user input.
if A1 and B1 are both filled then the analysis/program will begin

I have no idea how to accomplish this, any help would be great. thanks in advance
please help

gbianchi · April 21st, 2009, 02:47 PM

Hello.. your pseudo-code is great, that's the way to resolve it.. what do you need?? code??? I don't think nobody will code for you.

seventy9mph · April 21st, 2009, 03:36 PM

I can do it for a formula If-then, but I can't write it in code. I need some direction for code because the cell needs to be auto fill if a condition 'A" is met and if not, then user input. As you know, if it is in a formula and user types in that cell, the formula is lost.
that was my thoughts, any thought you might have would be greatly appreciated

gbianchi · April 21st, 2009, 06:14 PM

If you want to use VBA, there are several (lots!) of faqs at google. Anyway, if you have the formula, why not just use it in another cell, block that cell and it use from there???