Need some reference videos to make required program in VBA

Question

0.00/5 (No votes)

See more:

I need to automate one client report which is in format. I need to apply some formatting & formulas as per business requirement. Could you please help with some reference video's of VBA where below requirements codes are explained.

Requirements: - 
1.	Insert 2 rows after word BM or HB in column A
2.	Place concatenate formula after word BM or HB in column A
3.	Write word "Excess Return" after Fund & benchmark rows in column B
4.	Excess Return row to be bordered with Top & bottom border
5.	Place arithmetic formula in Excess return row. E.g =IFERROR(A2-A3,"")
6.	Above process should in looped until word NOTE and then loop should end.

What I have tried:

I have not tried anything yet as I am not much familiar with VBA codes. Need to start learning but before that if would get help of some video's which can help me to make code for my above requirements would be helpful. Thanks in advance

Posted 19-Dec-21 23:14pm

Member 14124697

Updated 19-Dec-21 23:45pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2021-12-19T23:45:00

You are not going to learn how to do this from any video.

My advice would be to use the Macro recording function in Excel
- Make sure the Developer Tab is available in the Ribbon
- Select Macros, Record Macro
- Manually do the above steps
- Select Macros, Stop Recording

Examine the code that has been recorded to understand how to continue. Do not just leave the code "as is", it will require attention.

Next get yourself a good book or a course and start to learn VBA - here are some resources, but note that I do not necessarily endorse or recommend these
Learn VBA Online – Tutorial for Beginners (Free & Interactive)[^]
https://www.coursera.org/courses?query=vba[^]
Excel VBA Programming - a free course for complete beginners[^]