Question: This should be done on Excel using VBA. Please take a screenshot of the codes and the excel sheet. Thank you for your help! 1.
This should be done on Excel using VBA. Please take a screenshot of the codes and the excel sheet. Thank you for your help!

1. Problem: Consider that technicians in your department at XYZ Refinery input pH data from a process into a spreadsheet. To facilitate this, create a worksheet that has a button that, when pressed, displays an Excel userform with input boxes for date (user will input in format DD-MM-YYYY), time of day (format HH:MM in 24 hr format), and pH (0-14). You can assume the user will put in no bad or incomplete entries. Date and time will be typed in as shown above by the user. pH is input as a number. Show the data entered by the user in Column 1 to 3 (date, time, ph as column headers in row 1). After input, the user can push the button again to input another data set via the userform as often as needed. 2. Option Explicit Please make sure that the first line of your codes has "option Explicit". It is very crucial to include it 3. Writing comments to document programs Lines of comments should about equal or exceed lines of code
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
