Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Scenario Your manager likes the table you created with clients ABC, 123, and XYZ

by | Nov 25, 2021 | Computer and Web Programming : Visual Basic Programming | 0 comments

GET HELP WITH YOUR ESSAY

If you need assistance with writing your essay, our professional Essay Writing Service is here to help!

ORDER THIS OR A SIMILAR PAPER NOW

Scenario
Your manager likes the table you created with clients ABC, 123, and XYZ. They would like to have the table on an entirely new workbook and find a way to look up what each of their expenses are as well as other pieces of information.
Complete the two requests outlined below. Your manager shared an existing project similar to the one you will be working on and acquired the code to help expedite this project (Basic VBA.xlsm).
Before you begin:
Make sure you have the appropriate references checked! See instructions below:
Right-Click any of the tab names in the Ribbon at the top of the Excel Window  Click Customize the Ribbon to open Excel Options window
Go to Customized Ribbon section  Under “Main Tabs”  Make sure “Developer” box is checked, if not check the box  Click OK
Click the Developer Tab in the Ribbon  Click “Visual Basic” under ‘Code’ section to open VBA application
Click Tools in the Toolbar in VBA application  Click References
Find and make sure the following are checked:
Visual Basic For Applications
Microsoft Excel 15.0 Object Library
OLE Automation
Microsoft Office 15.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Scripting Runtime
Microsoft Windows Common Controls-2 6.0 (SP6)
Click OK
Request #1 – Make a subroutine using only code (in a module within the Excel Assessment file) that can:
Create a folder on your desktop called “[Your Last Name]_[Your First Name] Excel Assessment VBA”
Make an entirely new subroutine that can:
Make a new workbook
Copy the table contained in the ‘2. Formatting’ tab in the Excel file
Paste the table into a new workbook
Rename the worksheet tab in the new workbook to ‘Table Data’
Save the new workbook to the folder created on the desktop using the following name: “_  Excel Assessment VBA”
Save the workbook as a macro-enabled worksheet
Make the folder path universal so other people can create this folder too
Within the file title, add today’s date using the date format function, using the following format: dd-mmm-yyyy
After making these subroutines:
Create a button from the Developer tab so your manager can simply run your macro
Assign the button to the first subroutine you made
Repeat 1 and 2 for the second subroutine
Request #2 (Intensity Level 6) Make a new subroutine that gives the user information on some values from certain cells in a row using a message box and input box.
The input box will be used to look up the engagement name (by keyword) (e.g., “Americas” will yield “Americas LEP Remote Booking”)
The message box will give the following:
Client Name
Engagement Name
Engagement Partner
Total Expense
Charged Hours
TER
NER
SER
Create a button the same way you made the last one (manually), and assign it to the subroutine that produces the message box.

ORDER THIS OR A SIMILAR PAPER NOW

Our Services

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university, or professional, and we will assign a writer who has a respective degree.

Professional writers

We have hired a team of professionals who provide expert academic help. Most of them are native speakers and PhD holders who are able to take care of any assignment you need help with.

 

Free Revision

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support team.

On Time Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

24/7 Support

Our support agents are available 24/7 and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Original

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all sources and in-text citations. We also promise full confidentiality in all our services.

 

Pediatric Care

Customer satisfaction has always been one of our basic concerns. If you don’t feel satisfied with our delivered work, you can request for a refund.

 

Authentic Source

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

 

Our confidential essay writing service protects your privacy

We cherish your trust and do our best to protect you. Anything that you share with our private essay writing service is never misused as the access to your personal data is very limited. Your payment details and credit card number also fall under strict protection when you buy a custom essay online from us.

    Meet Our Team

    Wondering who’s working behind the scenes of our professional essay writing service? We have over 700 amazing people on our team including developers, QA engineers, designers, managers, HR specialists, marketers, essay writers, and many more. See who takes care of the orders you place.

     

    Super writers

    There are 400+ essay writers from all over the world on our team who go through a 3-step hiring process. We call them super-writers because most of them have master’s degrees; therefore, they know the ins and outs of the discipline in which they specialize.

     

    WOW-support

    Our extra-fast and caring support assistants answer your questions 24/7 and resolve any of your troubles. Our team was even nominated for the 2019 Best Quality Management Team Award by the European Contact Centre & Customer Service.

    If you are looking for a reputable and cheapest college essay writing service or homework help websites for college students to write your essay for you or do your homework, you are at the right place. We have more than 1000 essay writers who can help you write your essays for you. Just fill the order form above to submit your instructions and get an online essay helper or essay writer who can “write my essay for me”. Once you do, you will be happy that you used our essay services instead of any other online essay writing service.

    Talk To Us

    Need any help? Feel free to Send Us a Note

    Email:  support@eliteacademicessays.com