need help writing VBA Userform to display the random number for Triangular function . The result on the worksheet should be dynamically recaculated by just pressing F9
2. Display the specified number of random values Instead of using Ms worksheet where the worksheet by the user. gbox and Inputbox to get information from the user, create a simple arguments needed by the Triangular function can be typed into the . Y ou could also have the values entered on the Introduction worksheet. emember to use cell Styles to indicate which cells the user can input the values. (Do no use cell Styles for results generated using code.) When you have done all the work, Protect the worksheet but allow the users to select the cells and enter values, not do anything else to the spreadsheet Once you have th e function working, write a subroutine that takes the values the user pecified for min, max, likely, and total number of values, and display the specified number of random values on a new worksheet. ake sure you check to see if the new worksheet already exists, and delete the old one if it does The results do not need column headings. . The results must be dynamic, or volatile, so that pressing F9 (Windows) results in the function recalculating to produce different numbers (not having your code write out all the numbers again) Manual recalculation on a Mac is Command+= for the entire workbook. Specifically, you will write your 'function' into the results sheet, not outputting only numbers, and not using the Worksheet Function technique. (Yes, this is a bit tricky.) Generating large amounts of values (400+) with this technique may cause Excel to * . . temporarily become unavailable as all the functions are recalculated each time the next Turn off screen updating. (this may require some research) function is written to the spreadsheet. You carn . Set the calculation mode to manual until all the formulas are writen to the worksheet Just remember to turn both back on again when done. 2. Display the specified number of random values Instead of using Ms worksheet where the worksheet by the user. gbox and Inputbox to get information from the user, create a simple arguments needed by the Triangular function can be typed into the . Y ou could also have the values entered on the Introduction worksheet. emember to use cell Styles to indicate which cells the user can input the values. (Do no use cell Styles for results generated using code.) When you have done all the work, Protect the worksheet but allow the users to select the cells and enter values, not do anything else to the spreadsheet Once you have th e function working, write a subroutine that takes the values the user pecified for min, max, likely, and total number of values, and display the specified number of random values on a new worksheet. ake sure you check to see if the new worksheet already exists, and delete the old one if it does The results do not need column headings. . The results must be dynamic, or volatile, so that pressing F9 (Windows) results in the function recalculating to produce different numbers (not having your code write out all the numbers again) Manual recalculation on a Mac is Command+= for the entire workbook. Specifically, you will write your 'function' into the results sheet, not outputting only numbers, and not using the Worksheet Function technique. (Yes, this is a bit tricky.) Generating large amounts of values (400+) with this technique may cause Excel to * . . temporarily become unavailable as all the functions are recalculated each time the next Turn off screen updating. (this may require some research) function is written to the spreadsheet. You carn . Set the calculation mode to manual until all the formulas are writen to the worksheet Just remember to turn both back on again when done
