VBA or function to test if cell contains a value or a formula?

[EssKayKay]

Is there a way to test if cell contains a value or a formula? I assume “=IsFormula()” but apparently I’m missing something. I’d like to either run this directly from VBA, something like either one of the following:

1. If B100 is formula (not a value) then do THIS otherwise do THAT.
2. If B100 is value (not a formula) then do THIS otherwise do THAT.

OR by placing the function in an adjacent cell to return YES or NO.

Thanks,
Steve

 

[Joe4]

Which version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’).

It looks like the IsFormula was introduced with Excel 2013 for Windows and Excel 2011 for Mac.
See here: ISFORMULA function - Microsoft Support

 

[EssKayKay]

Ah, thank you Joe. Yes, I am using an OLD version (2007) so I assume that is the problem. So short of that, is there any other work-around to deal with this on older versions?

Regarding my Account Details, I thought I had included that - my Bad, sorry.

 

[Joe4]

Ah, thank you Joe. Yes, I am using an OLD version (2007) so I assume that is the problem. So short of that, is there any other work-around to deal with this on older versions?

Regarding my Account Details, I thought I had included that - my Bad, sorry.

I have seen people make up their own function that does the same thing that the IsFormula function does. It is very short/simple code.
Here is a thread that has one you should be able to use: Excel IsFormula Function Alternative Formula

 

[EssKayKay]

Excellent, I'm going to try that.
Thanks again Joe. . .

 

[Joe4]

You are welcome.