News from CrosVBA
2026-03-17
I have made a new version of CrosRisk. This has been made even more flexible and efficient by help of advanced array function. Typically a report with many XLOOKUP functions, has been replaced by one LET function. Some functionality in VBA has been replaced by M code in Power Query.
Actually I have not only one new version, but two. I made a CrosRiskPlus version where you can have risks in different currencies, and where you can make reports in the currency you want. This flexibility comes with an addition complexity in the workbook. As most companies and projects only use one Base currency, I have made CrosRiskMin, where you only enter risks in the Base currency and where you only can make reports in this currency. The data tables are the same, so you will be able to "upgrade" if you later find out that you need more currencies.
I'm eager to try this out on a real case, and I'm willing to make a risk assessment for you free of charge.
From this News page, you might get the impression that I'm only occupied with the risk programming. I'm not. But this workbook is so general, it could be used for any company or project directly with stunning results the first day.
2025-11-18
I'm still here. Ready to take on new projects for free. My knowledge of Excel are improving in pace with Excels development.
2024-11-09
I'm still impressed by the new features in Excel and the opportunities they present when combined. As a result, I've been relying less on VBA and resolving most issues directly in the sheets.
2024-06-01
I am surprised that no one so far has demanded CrosRisk. It is free and it is good.
I am amazed by the development of Excel, new functions are coming every month. Functions like LET, PIVOTBY and LAMBDA are mind blowing.
2023-03-01
I still mainly working on "projects" that I create for myself, but I also have had the pleasure of helping other people and businesses. My skills regarding Power Query (and M) and Power Pivot (and Dax) are gradually improving. The VBA connected to Excel tables has become more second nature.
2022-11-14
Keeping up with all the new array function in Excel is a very pleasant struggle.