Answered step by step
Verified Expert Solution
Question
1 Approved Answer
- 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started