![]() You cannot calculate Bloomberg formula with UserForm activated If no (false), it'll calculate the activesheet again in 5 seconds. ![]() If yes (true), it'll proceed to do the work inside the IF-Then statment. That If-Then statement fires a little function to test whether the activesheet has been fully refreshed. The macro "run_part1" is the macro you kick off. In order to achiveve this, here I'm introducing a "standard" approach in VBA, making use of the "OnTime" method. It means, you macro needs to be intelligent enough to "wait" for the bloomberg formulas to be fully refreshed before proceeding. When an BBG formula calculates, it will show "#N/A Requesting Data." (see picture below) for a while, ranging from a second to a few minutes, depending on the amount of data you're requesting. ![]() It takes time for Bloomberg formulas to refresh. However, for Bloomberg formula, this won't work properly. Normally, you use "Calculate" method to calculate a sheet/range. The Essential Correct Approaches to Refresh Bloomberg Formula in VBA ![]() Excel Power Expander Worksheet Function Reference.Welcome to Vonixx, the Real Excel Automation Expert
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |