비주얼베이직 프로그램 교육 초보자 용 시간단축 강좌 1 Visualbasic Tutorial

강의 미리보기





비주얼베이직 실습 강의 주소 입니다.
https://www.alzio.co.kr


#비주얼베이직#비주얼베이직기초#비주얼베이직강좌
김현중 : 증권사에서 클라인언트 화면단 업무를 하고 있습니다. 혹시 vb스크립트 언어를 사용중인데 비주얼스튜디오2019로 영상도 올려주실 수 있을까요?

엑사남의 VBA 기본강의 1강

엑사남에게 배우는 엑셀VBA 기본 무료강의 입니다
엑셀 VBA 공부 쉽게 하려면
무조건 보시는게 좋을거에요 ^^
모두에게 도움 되기를 바랍니다.
상식과기본 : 이런 양질의 강의가 무료라니 너무 좋습니다.
MVM s : ㅠㅠㅠvba 배워보려고 여러 기초 강의들을 들어봤는데, 이렇게 간결하게 바로 적용할수있는 강의는 처음본것 같습니다 감사합니다 앞으로 올려주신 영상들 다 찾아보고 vba 고수가 되겠습니다!!!!
김범식 : 이런 강의가 있다니!! 감동입니다~ 정말 감사드려요!! ㅠㅜ
pmsrlee : 덕분에 인생 최초 VBA 코드를 짜보았습니다. 기분 좋네요. 새롭게 시작할 수 있도록 훌륭한 강의를 올려주셔서 감사합니다.
이규봉 : 알고리즘이 이제라도 나를 이 강의로 이끌어 줘서 행운이라고 생각합니다.

Excel VBA Beginner Tutorial

Excel VBA Beginner Tutorial

For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Join our online community! - https://www.offsitebylearnit.com

Excercise Files: https://bit.ly/3kVR38Y

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection \u0026 Color 1:47:14
Value and Clear 1:52:16
ActiveSheet, Sheets, and Name 1:54:01
CurrentRegion 1:56:40
Practice 1:58:08

#ExcelVBA
Learnit Training : The link to the exercise files is in the video description
TECSPURT Tips : I've only just started listening to this (earphones) and the presentation in terms of audio is fully engaging and exciting. You will have me for over 2 hours
lesnyk255 : I taught myself some VBA by back-engineering macros I'd recorded, but there's SOOO much more to it that I've never understood. I'm 25 minutes into this and I've already learned several tricks that will make life easier! Taking a break now, but I will be back for more. This is a godsend.
Sridhar Sockalingam : This course was the best among several I tried out recently. It assumes that you do not know anything or very little about Macros and VBA and walks you thru them step by step. Absolutely great teaching method. Very well paced and with clear explanations and examples. The downloadable files make it so easy to practice as well. Thank you for the excellent course!!
J Loo : Best VBA lesson I have take so far. I bought many books but lost interest on the complexity. Thanks for making it so simple and interestingly. God bless you, Dan and team in this channel

...