Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
distinguishing between cell formula, and the resulting text in cell
Hope I explain this good enough.
Cell A6 has an If-then formula that will show "Send Now" in the cell if the date in another column matches a certain criteria. =IF(E7<1,"",IF(E7<=WORKDAY(TODAY(),1,Holidays_2007 ),"SEND NOW","")) The cell will show SEND NOW if the criteria matches. Otherwise the cell will have the formula in it, but will look blank. I'm trying to write a macro that will recognize when the cell shows Send Now, as opposed to just the formula. Here's a simplified version of what I want. This doesn't work, but it shows the concept of what I'm trying to do. Range("A6").Select 'cell with the formula in it If ActiveCell.Value = "Send Now" Then 'How do I write this line so that SEND NOW is recognized? Range("L8").Select ActiveCell.Value = "Send Now" End If I've search Help, and other postings here, but can't find the answer. If you could help, I'd appreciate it very much. Thanks, J.O. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
distinguishing between cell formula, and the resulting text in
I appreciate the help of everyone. GEEZ. I didn't see the upper/lower
case problem. Great suggestions. Also, thanks for showing how to write the code a little cleaner. Thanks again. J.O. Tom Ogilvy wrote: Missed that you were writing to L8 if lcase(Range("A6")).Value = "send now" then Range("L8").Value = "Send Now" else Range("L8").clearcontents End if -- Regards, Tom Ogilvy "Tom Ogilvy" wrote: if lcase(Range("A6")).Value = "send now" then msgbox "Send Now End if Don't set the value of the cell with code, or you will overwrite your formula (unless that is what you want to do). The test for not send now would be if Range("A6").Value = "" then msgbox "don't send now" End if -- Regards, Tom Ogilvy "excelnut1954" wrote: Hope I explain this good enough. Cell A6 has an If-then formula that will show "Send Now" in the cell if the date in another column matches a certain criteria. =IF(E7<1,"",IF(E7<=WORKDAY(TODAY(),1,Holidays_2007 ),"SEND NOW","")) The cell will show SEND NOW if the criteria matches. Otherwise the cell will have the formula in it, but will look blank. I'm trying to write a macro that will recognize when the cell shows Send Now, as opposed to just the formula. Here's a simplified version of what I want. This doesn't work, but it shows the concept of what I'm trying to do. Range("A6").Select 'cell with the formula in it If ActiveCell.Value = "Send Now" Then 'How do I write this line so that SEND NOW is recognized? Range("L8").Select ActiveCell.Value = "Send Now" End If I've search Help, and other postings here, but can't find the answer. If you could help, I'd appreciate it very much. Thanks, J.O. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula does not display the resulting value in the cell | New Users to Excel | |||
auto change cell text colour resulting from a condition | Excel Worksheet Functions | |||
Results no longer currency when adding text to formula / formulas based on resulting cell don't work. | Excel Programming | |||
My formula show up in the cell instead of a resulting value | Excel Worksheet Functions | |||
Distinguishing cell formula from value. | Excel Programming |