Get Formula or FormulaArray from InputBox

Hello,

I am wondering how do I capture if the formula that user has put in the InputBox if it's a regular formula or an Array Formula.

PS: I'm trying to avoid userform completely here

Salut !

Good question ! Maybe I'm wrong but I think it can be only a regular formula, did you try ?

Yes...regular formula has no problem.

The problem that I'm facing here is that if user were to have an array formula as their input, how am I going to handle it then.

That's why I need to know if it's a regular formula or an array formula.

Try first adding the famous { } characters we can see when it's a valid array formula inside a cell.
If the input box accepts them, it will be easy to detect the first character and to use the appropriate property accordingly …

That's what I thought...when I add the {}, it returns as a string instead of a formula