Last seen: May 22, 2025
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?
Add a column with 1s in it and another column that multiplies the Total Amount column by this new column. Then change N2 to total the multiplication c...
Since you essentially need to test every possible combination of values, you'll need a recursive routine such as the one posted a little over halfway ...
What are the constraints? What if more than one combination adds up to the value in question? (this is a considerably more complicated question than t...