VBA Function Background Operation

ranouilh

New Member
Joined
Apr 26, 2005
Messages
16
I wrote custom VBA functions in Excel that stop continuously calculating when I activate a different workbook. They are populated with RTD streaming from ThinkorSwim and generate audible alerts when certain conditions are met. They work great until I open/activate another workbook and then they display #Value . If I go back to the workbook with the functions and click on it to make it active again the functions start calculating again. Is this typical? And does anyone know a possible workaround?

Note: The RTD formulas in the spreadsheet continue to work even when the 2nd workbook is active. Using 2019 64bit Excel.
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,099,363
Messages
5,468,186
Members
406,570
Latest member
Ktvu2006

This Week's Hot Topics

Top