Request user input from inside a LAMBDA?

Copper Contributor

Say I have a simple LAMBDA function:

=LAMBDA(number,number+1)

 

is there a way to obtain the "number" by popping out an input box with a prompt like "give me a number"?

3 Replies
As far as I've been able to ascertain you can't use LAMBDAs like VBA to perform interactions or manipulations of things outside the scope of the grid. I'd be thrilled to be shown that I'm incorrect, however.
Yes, I was afraid of that. But what with Excel+Lambda now "being Turing complete" and all, I was hoping maybe....
Maybe MS will build in a way to do that eventually? You can't open a door that doesn't exist, though. Being Turing-complete just means we should be able to calculate pretty much anything that can be calculated within reason.