Last seen: Jun 12, 2026
The issue with the SUMPRODUCT and SUMIF construction is that you're basically doing this: SUMIF(E2:E12,K2)+SUMIF(E2:E12,K3)+SUMIF(E2:E12,K4)+... and s...
I'd assume it's your regional settings. You probably need something like: =COLUMNS({123;0})
Your ReadOptionBoxes routine uses the active cell, but your UpdateDisplay routine doesn't move the selection until after it's populated everything. If...
You could just put them into a 2 column table/range, then simply process each row using the first column as the frame name and the second as the offse...
Hi, It looks to me like you just need to alter the logic slightly: For Each Ctrl In frmNewRecords.Controls(stframe).Controls If TypeName(Ct...
Just a small note that nested IF is more efficient since IFS evaluates everything passed to it, no matter which order you do it in.
Just remove the +0 from the formula, since your values are not numeric. If you need to handle both numbers and text in the same formula, you could use...
Tables aren't really that good at that kind of formula. Simple way round it is to use something like: =COUNTIF(INDEX([Invoice],2):[@Invoice],[@Invo...
If you're using VBA you could just use the code to populate the text box.
In your ValidEntry function you have code like this: .txtLastName.Text = vbWhite which will put the value of the vbWhite constant (which ...
Steve, My point is that if your workbook opens in protected mode and you then enable editing and macros, any code run in the Open event will not be...
Nothing in your code is 32 vs 64 bit specific. On the computers where it works, are you prompted to enable editing?
Does it work properly if you enable macros, then save close and reopen the workbook? I suspect protected mode is interfering.
You could add a query that calculates the highest length match for a given document, and then only return the rows that match on both document name an...
Can you clarify what is missing in that example and why?