Question: - Prepare a userform where the input fields are o Book Name ( text ) o Book Author ( text ) o ISBN No (
Prepare a userform where the input fields are
o Book Name text
o Book Author text
o ISBN No unique number
o Selling Price Currency between $ and $
o Last Months Sales Quantity integer between and
In the form there should be Save Data, Close Form buttons. Each record should be added to a new line.
Prepare a second form reachable from the first form where
o there are summarizing fields where you calculate the total monthly revenue total quantity sold best selling books title revenue of best selling book to total sales
o You can display the details of a book when you enter the ISBN no so there will be a field where you enter ISBN no and when you click it it should display all the details about that book
Fill with at least book data you can randomly give numbers and names... PLS WRITE A VBA CODE. other cods in chegg does not work. so please be careful thank you.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
