javascript THIS in vba

[hemis]

Hello

Is there an equivalent function in VBA as THIS in javascript?

Regards

 

[Rick Rothstein]

Is there an equivalent function in VBA as THIS in javascript?

I don't know javascript, so I looked up the THIS keyword online. If I understand what I read correctly, the answer is "maybe". When you put a UDF (user defined function) in a cell, Application.Caller will return the cell where that function is executing from. There are a couple of other situations where Application.Caller could be used, so you should look it up in the help files. Other than that, I do not believe VBA has an equivalence to the THIS keyword in javasc

 

[hemis]

Rick

You have answered my question. I will explore the .Caller method.

Thanks