Convert XLM macro to VBA

[JunglesMcBeef]

Hey All,

I have a simple XLM statement that has confused me for a while now, i can't understand it. Can someone please interpret this to VBA for me:

=IF(NOT(!FEM2>""))

I don't understand the !FEM2>"" side of it. I know that - !FEM is a reference to a cell, but I can't see how a numeric value can be greater than "" or how this conditional statement can even execute when the 2 comparison data types aren't the same.... Please help!!

 

[PHV]

Take a look here:

http://www.microsoft.com/downloads/...FamilyID=C09BF7F7-D30E-4CE9-8930-5D03748CA5CD

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JunglesMcBeef]

I have this file already.... I know how IF statements work, how cell references work, and how the overall statement works...But if you read my question again it's more to do with the logic, less to do with syntax. How can a cell value be greater than ""? does it mean string length?

 

[JunglesMcBeef]

Another thing, how can I create an XLM macro? Do I need a copy of Excel 4.0?

 

[PHV]

Insert a Macro Sheet

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JunglesMcBeef]

Thanks for that.

In the end it logically worked out how I expected. If !FEM2 was nothing then it worked out true. Which I am guessing means that when a cell reference is used along with >"" in a conditional statement it means to check whether any data exists within the cell. So in reality the answer to my original post is:

=IF(NOT(!FEM2>""))

looks like this in VBA:

If Not fem2 > "" Then

Seems simple but XLM is a complete hassle, cheers.