Now do the following:
(i) ‐ ask the user how many units of Machine 1 they would like to purchase and store this value to an integer data type.
‐ title of this dialog box must be "Query"
‐round the user input into an integer data type so that it would be okay even if the user entered something like 2.4.
‐insert this value into cell J6.
(ii) ‐ ask the user how many units of Machine 2 they would like to purchase and store this value to an integer data type.
‐ title of this dialog box must be "Query"
‐round the user input into an integer data type so that it would be okay even if the user entered something like 2.4.
‐insert this value into cell J7.
(iii) ‐ ask the user how many units of Machine 3 they would like to purchase and store this value to an integer data type.
‐ title of this dialog box must be "Query"
‐round the user input into an integer data type so that it would be okay even if the user entered something like 2.4.
‐insert this value into cell J8.
The below example shows what your sheet would look like after the user entered a value of 15.3 or 15 in part(i), and the program is currently asking the user to enter the number of units of Machine 2 they would like to purchase when (ii) is executed.
- Can You Put This In Vba Excel Now Do The Following I Ask The User How Many Units Of Machine 1 They Would Like To P 1 (64.91 KiB) Viewed 31 times