Dear all,
Only for example I am having 1 carton, suppose its weight is 80 kg and in that carton, I am having 15 small cartons inside so I want to calculate the Length Breadth & height. Following, is how it suppose to work User will enter only weight and total cartons, after finishing this hit calculate button, so it need to update automatically with Length, Breadth & height, in text box. User can see the changing the figure of Length Breadth & height. Excel sheet means main window suppose to hide all the time. If user close the userform then at same time excel sheet suppose to be close. Please help me in this. Attached sheet for your reference. Thanks & Regards, Prajakt Pande +971551388482 ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
Calculator.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
