Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba intermediate and advanced

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Vba intermediate and on to the advanced course

Vba intermediate and on to the advanced course

ResolvedVersion 2010

Frank has attended:
Access VBA course

Vba intermediate and on to the advanced course

how do i consolidate on this learning on regular basis?

RE: vba intermediate and on to the advanced course

Hello Frank,

Hope you enjoyed your Microsoft Excel VBA course with Best STL.

Thank you for your question regarding ongoing advancement using Excel VBA.

VBA has many levels and to understand the many different ways to write code which may do the same thing, for example, you have to experiment. Try create macros and then view the code. Comment out any lines of code you feel are not required. Run the code again and if it is successful then you can safely delete the commented out code.

Consider actions which you perform in Excel on a daily basis and think how you may be able to automate these actions with macros/VBA code. by doing this on a regular basis your knowledge will grow.

Buy books and invest in yourself.

I hope you will have great success using VBA.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.