Len IF Code

[vasto]

we are trying to use the following IF len code to identify cell d5(in currency format) when d5 equals $0.00 we want the msgbox to pop up.

Please Login or Register  to view this content.

[DonkeyOte]

Why not test the value ?

Please Login or Register  to view this content.

If the $ is applied via formatting it won't affect the underlying .Value of the cell (ie 0 formatted as $0.00 has a Len of 1 not 5) if you want to test Len of cell content post-formatting you would need to test against the .Text property.