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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks