Flashing Formula Excel - Caused by VBA?
Posted on 2016-09-06
I am working on a project with many userforms with a wide range of controls (listboxes, textboxes, MonthView etc.) using Windows 10.
Once data has been added to the worksheet, the formula bar keeps flashing. This also happens when I add data from a userform which doesn't have the standard controls.
The worksheet does not have any shapes: just listboxes, charts and pivot tables. Formulae are kept to a minimum as the logic is implemented in the userform. I decided to use this method as I have thousands of entries in various tables.
What are the likely causes of the formula bar flashing?
Has anyone experienced the same problem in the past?