LinkBack URL
About LinkBacks
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.
If Len(Sheets("Parrs").Range("D5").Value) = 1 Then Cancel = True MsgBox "Test" Else
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.
If Len(Sheets("Parrs").Range("D5").Value) = 1 Then Cancel = True MsgBox "Test" Else
Last edited by vasto; 09-01-2009 at 01:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks