View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Vick
 
Posts: n/a
Default Using a Input Box Value in an if statement

This looks like a formula, I'm looking for this in terms of a macro. Thanks
for the help though.

"Marcelo" wrote:

Hi Vick,

try if(vdate=6,"true","false")
you just replace the "true" and "false" for you need.

hope this help.
regards from Brazil
Marcelo

"Vick" escreveu:

I'm trying to create an If, then, else statment using the value of an input
box.

So lets say the variable of my input box is vdate and it returns 6 how would
I write the IF statement to true if vdate = 6. If VDATE = 6 then? What am I
missing?

Thanks for your help!