Windows 10: Excel VBA -- Why are some functions running without being called?

Stepping through some code while debugging, I find that some functions are being run without my explicit calling them! The Call Stack shows, preceding the function call, "[<Non-Basic Code>]" I did have some Application.Volatile statements but commenting them all out did not help. There was a Worksheet_Change event for one sheet, but commenting that out did not help either. Where else can I look?[Windows 10 / Excel 2019 Pro]P.S. the Topics list does not include an appropriate one for this topic. "Settings" that I picked is wrong. Please add something like MS Office.

:)

 

VBA code to simulate Excel LET function? use LET before available

Hi there

@sunny123

perhaps for those who don't know or haven't understood the LET function -- this explains it :

The New Excel LET Function: How to Use It & Why You'll Love it

I'd assume that any version of EXCEL (alternatives to Ms OFFICE) that doesn't have some sort of "in line coding --e.g VBA type of thing) or abilities to create functions or procedures would be a non starter.

However with earlier versions of Ms EXCEL it might be possible to replicate this -- am looking into the possibilities.

The Define Name function probably is your best bet for this. Not quite 100% the same but near enough.

Create Custom Functions Using Names - MS-Excel Tutorial

Cheers
jimbo

 

VBA code to simulate Excel LET function? use LET before available

Hello, if anyone done VBA to simulate LET function, I appreciate where to find this (free or pay) source code if possible.

https://answers.microsoft.com/en-us/...f-a5ca994a766a

Helper cell to to contain final code. VBA to convert to LET-less formula for cell ; when LET avails, also only 1 step away (C&P helper to cell). Easier to troubleshoot but need to remove helper

 

DDE link in Excel crash when I open VBA in Excel wirh Windows10

Good Morning.

I,ve installed windows 10 about 20 days ago.

I've also Microsoft Excel 2007 and I use much VBA Excel and DDE links in my worksheets in Excel.

Before installing Windows 10 I use Windows XP ( with the same Excel 2007 thet I reinstall on Windows 10)

With Windows XP, some times when I need to change istructions in VBA, also if my worksheets was linked with DDE, I opened VBA VisualBasic and I can work in my VBA application.

No problems.

Now, with windows 10, when I open in Excel Visual Basic java links DDE Excel crash.

All works well ( DDE, Excel, and other software ) but whan I open visualbasic in Excel Java Crash.

Any suggest?

Thanks