Home دروس VBA

أساسيات VBA الاكسل : مقدمة حول دورة VBA

September 17, 2021

مقدمة لتعلم لغة VBA في برنامج microsoft excel

VBA (Visual Basic for Applications)

هي لغة قريبة من Visual Basic والتي تتطلب تشغيل تطبيق مضيفExcel في حالتنا.

بفضل VBA ، سنكون قادرين على تحقيق أي شيء نريده تقريبًا باستخدام Excel ...

لكن قبل أن نبدأ ، لنبدأ بعرض الأدوات التي سنحتاجها.

إذا كنت تستخدم إصدار 2007 من Excel أو إصدار أحدث ، انقر فوق "نعم"ملف خيارات تخصيص الشريط ثم ضع علامة مطور.

اضغط على زر الأيمن للماوس ثم اضغط على personnaliser le ruban كما هو موضح في الصورة ادناه.

مقدمة لتعلم لغة VBA في برنامج microsoft excel

ستتم إضافة علامة تبويب جديدة:

مقدمة لتعلم لغة VBA في برنامج microsoft excel

مقدمة لتعلم لغة VBA في برنامج microsoft excel

للعمل مع رمز VBA ، نحتاج إلى محرر ، وهو مثبت بالفعل ويمكنك فتحه باستخدام الاختصار Alt + F11 :

مقدمة لتعلم لغة VBA في برنامج microsoft excel

سنعود إلى ذلك ، فقط تذكر الاختصار Alt + F11 حاليا ...

Tags دروس VBA

Latest articles from : دروس VBA

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY6AeDijHqXFki9gwkducew2Hehnhg:1714142518495';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/06/vba.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/06/vba.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/06/vba.html', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-204466697-1', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/4881403023530688763/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/16e657cb9c57b8a2', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '4881403023530688763', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQA8jM4kbwPcflpyLjrh4jiLXogvAsfIHVQ-lp6JOwy5iqEdiW307SS6QPaQSgcPKrcS0rzbAq_IIx_FPwI4VjymLE0CjlOqsB_CNBmriKKs0co8kazMfRQl-GrkkiSbZgXdc0L9BVNVY/s72-c/1.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQA8jM4kbwPcflpyLjrh4jiLXogvAsfIHVQ-lp6JOwy5iqEdiW307SS6QPaQSgcPKrcS0rzbAq_IIx_FPwI4VjymLE0CjlOqsB_CNBmriKKs0co8kazMfRQl-GrkkiSbZgXdc0L9BVNVY/s16000/1.png', 'pageName': '\u0623\u0633\u0627\u0633\u064a\u0627\u062a VBA \u0627\u0644\u0627\u0643\u0633\u0644 : \u0645\u0642\u062f\u0645\u0629 \u062d\u0648\u0644 \u062f\u0648\u0631\u0629 VBA', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0623\u0633\u0627\u0633\u064a\u0627\u062a VBA \u0627\u0644\u0627\u0643\u0633\u0644 : \u0645\u0642\u062f\u0645\u0629 \u062d\u0648\u0644 \u062f\u0648\u0631\u0629 VBA', 'metaDescription': '\u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0633\u062a\u062e\u062f\u0645 \u0625\u0635\u062f\u0627\u0631 2007 \u0645\u0646 Excel (\u0623\u0648 \u0625\u0635\u062f\u0627\u0631 \u0623\u062d\u062f\u062b) \u060c \u0627\u0646\u0642\u0631 \u0641\u0648\u0642 \x22\u0646\u0639\u0645\x22 \u0645\u0644\u0641 \u062e\u064a\u0627\u0631\u0627\u062a \u062a\u062e\u0635\u064a\u0635 \u0627\u0644\u0634\u0631\u064a\u0637 \u062b\u0645 \u0636\u0639 \u0639\u0644\u0627\u0645\u0629 \u0645\u0637\u0648\u0631.\u0627\u0636\u063a\u0637 \u0639\u0644\u0649 \u0632\u0631 \u0627\u0644\u0623\u064a\u0645\u0646 \u0644\u0644\u0645\u0627\u0648\u0633 \u062b\u0645 \u0627\u0636\u063a\u0637 \u0639\u0644\u0649 '}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0623\u0633\u0627\u0633\u064a\u0627\u062a VBA \u0627\u0644\u0627\u0643\u0633\u0644 : \u0645\u0642\u062f\u0645\u0629 \u062d\u0648\u0644 \u062f\u0648\u0631\u0629 VBA', 'description': '\u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0633\u062a\u062e\u062f\u0645 \u0625\u0635\u062f\u0627\u0631 2007 \u0645\u0646 Excel (\u0623\u0648 \u0625\u0635\u062f\u0627\u0631 \u0623\u062d\u062f\u062b) \u060c \u0627\u0646\u0642\u0631 \u0641\u0648\u0642 \x22\u0646\u0639\u0645\x22 \u0645\u0644\u0641 \u062e\u064a\u0627\u0631\u0627\u062a \u062a\u062e\u0635\u064a\u0635 \u0627\u0644\u0634\u0631\u064a\u0637 \u062b\u0645 \u0636\u0639 \u0639\u0644\u0627\u0645\u0629 \u0645\u0637\u0648\u0631.\u0627\u0636\u063a\u0637 \u0639\u0644\u0649 \u0632\u0631 \u0627\u0644\u0623\u064a\u0645\u0646 \u0644\u0644\u0645\u0627\u0648\u0633 \u062b\u0645 \u0627\u0636\u063a\u0637 \u0639\u0644\u0649 ', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQA8jM4kbwPcflpyLjrh4jiLXogvAsfIHVQ-lp6JOwy5iqEdiW307SS6QPaQSgcPKrcS0rzbAq_IIx_FPwI4VjymLE0CjlOqsB_CNBmriKKs0co8kazMfRQl-GrkkiSbZgXdc0L9BVNVY/s16000/1.png', 'url': 'https://www.practiceexcel-365.com/2021/06/vba.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 4881403023530688763}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Practice Excel365 | Free Excel Courses (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '4881403023530688763', 'title': '\u0623\u0633\u0627\u0633\u064a\u0627\u062a VBA \u0627\u0644\u0627\u0643\u0633\u0644 : \u0645\u0642\u062f\u0645\u0629 \u062d\u0648\u0644 \u062f\u0648\u0631\u0629 VBA', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQA8jM4kbwPcflpyLjrh4jiLXogvAsfIHVQ-lp6JOwy5iqEdiW307SS6QPaQSgcPKrcS0rzbAq_IIx_FPwI4VjymLE0CjlOqsB_CNBmriKKs0co8kazMfRQl-GrkkiSbZgXdc0L9BVNVY/s16000/1.png', 'showInlineAds': true}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1666805145-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY4V27_8bobwaaqy3-x3gVR-bUnz3g:1714142518496', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));