Console question

[Almesi]

Hey there, i got a question regarding the stdLambda console.
I am currently working on the lambda implementation and it works good so far. But i dont know how i would include bind, bindex and bindglobal.

My problem is the following:
I would like it to be usable without stdlambda if possible.
With this in mind i tried to create a dynamic array variant which holds name, equation, cache and sandbox for every created array.
A lambda object is then created "on the fly" and destructed right after execution.

The thing is: this work great with create/run, but i dont know how to implement binding variables to each element.
The obvious solution is to change the array to stdlambda from variant, but if possible i would like to avoid it.
Do you have any insight for me?

[Almesi]

I can send a pull request later for the exact code.

[sancarn]

I too was wondering how to do variables.

• stdLambda does have local variable support, but currently these aren't really accessible after evaluation.
• stdLambda does have globals via the oFuncExt or bind global, but then has no way of changing those globals at runtime.

But one option would be the following:

Private varsDict as object: set varsDict = CreateObject("Scripting.Dictionary")

Private Sub ExecuteCommand(ByVal command as string)
  Call stdLambda.Create(command).bindGlobal("vars", varsDict)
End Sub

Which would allow for the syntax:

let vars.myVar = ThisWorkbook.name

for instance. And will change the same fixed dictionary every time. This is probably the best option until local vars are obtainable and modifiable outside of lambda.

[Almesi]

I think i got a solution. I'll inform you when its ready.
I have another question.
Currently the Form uses an InkEdit Control to show both Text and different Textcolors.
If i am to implement stdUIElement i would have to use one of the given Controls of your Class. So if should implement both i would need the InkEdit control implemented in stdUIElement.

If you give me the GO for it i will work on that too.

[sancarn]

If i am to implement stdUIElement i would have to use one of the given Controls of your Class. So if should implement both i would need the InkEdit control implemented in stdUIElement.

I think if this were me I'd add a Public Function CreateFromTypeName(ByVal oControls As MSForms.controls, ByVal CtrlTypeName As string) As a result I'd probably export the control type to name functionality to it's own function too. But more of a problem is the events interface... We'd need to really do late bound events... So I think this requires a lot more thought. So for now I'd avoid building this into stdUIElement, and just use stdUIElement if it's necessary anywhere else. I have many examples where I don't use it.