Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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!

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

6. Does your speech have a clear and logical structure?

Answered: 1 week ago