I created the table with constraint percentage cannot more 100% for total category, but i cannot make it should be 100% for total
aUGydBfHRvZweXjG4QFMFZ.xlsx (6.9 KB)
I attached the xlsform, is there any more simple code to solve it.
Thanks in advance.
Maybe this post discussed previously should help you solve your issue:
Thanks for advice, Yes I tried to your approach function but same with my previous code. Its works when more than 100% constrainst message show up, but below 100% constraint message didn’t show up.
the code still allow input under 100%.
Maybe you will need to put a check at end to see if the total has reached 100%. And flag this out if it has not reached. Should should solve your issue.
thanks so much for your advice and support. Yes, I put in the tabel to show the total then validate if not reach 100%.
Table 33.xlsx (6.9 KB)
I just upload, if any other community search for it, if in the next something nice solution
Thank you for sharing it with the entire community and making this a learning and sharing platform @bwijoyo! Expecting the same in the upcoming days too.