VBA by MBA
VBA by MBA
  • 112
  • 29 892
C++ program as CV Template in Word document using Content Controls and Restrict Editing
Please take a look at the layout of the CV template that shows the C program:
1. The Name is represented at the start of the template, similar to the starting point of a program.
2. The Contact Information section, marked as comments in a C program, is where you can add your contact details.
3. The About Me section is a single paragraph that represents a function. You can write a brief introduction about yourself here.
4. Education is also a function and can include multiple lines, allowing for carriage returns to list your education details.
5. Work Experience is Currently, lists two jobs. Each job can have multiple lines, detailing different responsibilities.
6. Awards and Skills Both are functions that can also take multiple paragraphs, allowing you to list your awards and skills in detail.
NOTE: Best thing about this is that you can only edit the specific section of the template :)
Переглядів: 28

Відео

Interactive User Interface to control and Fill the Template from a folder Integration
Переглядів 127Місяць тому
In this video, we guide you through Version 1.3, which should be placed in the same folder as the 'Criteria' folder containing all your documents. Learn how to: Access the custom RibbonX tab with a button to open the User-Interface. Link the option button to the content control named 'Service Center'. Populate the criteria ListBox with document names from the 'Criteria' folder. Change the seque...
Excel Tutorial: Linking Sheets for Seamless Data Transfer | Copy Paste Without Format Change
Переглядів 823 місяці тому
This video contains following updates: - This particular worksheet "Purchase Order", spanning rows 12 to 29, is connected to another sheet extending from row 2 to 19. - Any alterations or copied content made in sheet "Input Sheet" will automatically reflect in the invoice sheet without altering its formatting. This means you can seamlessly copy and paste data in one sheet, and it will be mirror...
Enhancing Screenshots with Paint: Customizing UI Ribbon Tab for Client Presentations
Переглядів 133 місяці тому
Learn how to use Paint to edit screenshots for professional presentations. In this tutorial, we cover step-by-step instructions on enhancing screenshots to make them more visually appealing and representative to clients. From selecting areas to filling colors and removing unnecessary elements, you'll discover useful tips to create polished visuals. Master the art of using Paint to highlight key...
Yes! I have used the CSV as DataBase and I am proud of it
Переглядів 93 місяці тому
To update the database, I have modified the code with simple yes and no question. asking "if the provided name is a boy?". As user respond, the gender will be updated in the form-field as well as in the database, which is located at the desktop. ensuring that new entries are collected on the spot.
Word Template with Custom tab and button to be use as Add In
Переглядів 263 місяці тому
Tired of manually adding pictures to your Word tables? This video shows you how to create a custom macro that inserts pictures with invisible borders, saving you time and effort. Plus, learn how to add captions below the images with a second macro. 1. Now this Updated file (*.dotm) can be use as add-in, because I have introduced custom Tab with button to run the macro. - To use this document as...
Trigger Actions When Emails Land in Specific Folders - Outlook Event Listener for Specified Folder
Переглядів 273 місяці тому
Struggling to manage emails in different folders? This video shows you how to use Outlook Event Listeners to automatically detect when an email lands in a specific folder (like "Receipts with Tax"). We'll write a simple script that runs within Outlook and displays a message whenever an email is dropped into your chosen folder. This is a great way to stay organized and trigger actions based on w...
ActiveX vs. Content Controls: Macro Execution - Key Differences You Need to Know
Переглядів 203 місяці тому
Struggling to understand how Active X and Content Control macros work differently? This video breaks down the key differences between these two options in Microsoft Office. You'll learn that while both trigger macros, Active X executes them immediately upon selection, while Content Controls require an additional step like exiting by tab or clicking. In this video, you'll discover: - What Active...
Control Word document from Excel using Content Controls and VBA Macro
Переглядів 2103 місяці тому
This video demonstrates a powerful way to automate document creation using Excel VBA and Word content controls. You'll see how to: - Integrate a date picker calendar for user-friendly date selection. - Create dynamic drop-down lists that automatically update with new values. - Trigger a macro with a custom button to populate a Word template. - Fill text and checkboxes in Word content controls b...
VBA Tutorial: For Loop - Deleting Text Boxes in Reverse Order
Переглядів 103 місяці тому
Having trouble deleting all text boxes with VBA? In the previous attempt, we encountered an issue where some text boxes were skipped during deletion. This video explains the solution: looping through text boxes in reverse order This ensures all text boxes, regardless of their position, are detected and removed. Encounter issues when deleting text boxes in Word documents? Watch how to resolve sk...
Create Interactive User Forms in Excel including VBA code - Simple Step-by-Step Guide
Переглядів 4484 місяці тому
Learn how to prepare an Excel workbook for macros and create user forms in Excel VBA. This tutorial covers saving macros, displaying the Developer tab, and creating forms to gather user input. This step-by-step tutorial guides you through: 1. Preparing an Excel Workbook: Learn how to save macros in Excel for use with Word. 2. Showing the Developer Tab: Discover how to access the hidden Develope...
Automate Word Formatting with VBA Custom Add-In Button | Step-by-Step Guide
Переглядів 174 місяці тому
In this tutorial, learn how to streamline your document formatting workflow in Microsoft Word using VBA custom add-in buttons. Follow along as we demonstrate how to create a custom button that executes a macro to open documents from a specified folder one by one. You'll discover how to correct formatting inconsistencies, including page setup, margins, font styles, hyperlink management, headers,...
Mastering VBA Macros in Word: Utilizing Bookmarks for Dynamic Content Drop Down Effect
Переглядів 1294 місяці тому
In this tutorial, learn how to harness the power of VBA macros in Microsoft Word by effectively using bookmarks for dynamic content manipulation. We'll walk through the process of converting your document to .docm format to preserve VBA macros and strategically placing bookmarks to enable macro-driven hide and unhide functionalities. Additionally, discover advanced techniques to streamline user...
How to Stop Tab Key Adding New Rows in MS Word Table - Optimizing Word Forms
Переглядів 964 місяці тому
To prevent the addition of new rows when pressing the tab key in a fixed-structure Microsoft Word form, follow these steps: 1. Make sure the Developer tab is displayed. If not, go to File ~ Word Options ~ Popular, and check the box for "Show Developer tab in the Ribbon". 2. Place text entry points where users should type by clicking and then selecting either the Plain Text content control or th...
Filter Excel rows using Keywords and extract data into new file
Переглядів 274 місяці тому
Learn how to automate data extraction from Excel using VBA! In this tutorial, we'll show you how to create a custom Excel add-in with a user-friendly interface to search for specific keywords within the Description column. With step-by-step instructions, you'll see how to dynamically check and extract relevant rows, saving time and streamlining your workflow. Whether you're a beginner or an exp...
How to Password Protect Your VBA Project in Excel Step by Step Guide
Переглядів 674 місяці тому
How to Password Protect Your VBA Project in Excel Step by Step Guide
Step-by-Step Guide for Restrict editing in Word Document using Rich Text Content Controls
Переглядів 945 місяців тому
Step-by-Step Guide for Restrict editing in Word Document using Rich Text Content Controls
Efficient Document Editing Workflow: UI Integration Database Prices, and Two Decimals | VBA Tutorial
Переглядів 305 місяців тому
Efficient Document Editing Workflow: UI Integration Database Prices, and Two Decimals | VBA Tutorial
Automated Excel Workflow: Update 2024 Cumulative and Pairings Points Sheets with VBA Macro
Переглядів 1925 місяців тому
Automated Excel Workflow: Update 2024 Cumulative and Pairings Points Sheets with VBA Macro
Excel to Word Document Integration, and User-Friendly Features!
Переглядів 395 місяців тому
Excel to Word Document Integration, and User-Friendly Features!
Enhanced Word Database Management Tool | Version 2.1 Updates
Переглядів 399 місяців тому
Enhanced Word Database Management Tool | Version 2.1 Updates
Excel VBA Automation: File Renaming and HTML Conversion Tutorial
Переглядів 429 місяців тому
Excel VBA Automation: File Renaming and HTML Conversion Tutorial
Efficient Database Interaction with Excel: UI Walkthrough and Demo
Переглядів 459 місяців тому
Efficient Database Interaction with Excel: UI Walkthrough and Demo
Optimizing Your Excel Calendar: Dynamic Layouts, Status Tracking, and More
Переглядів 259 місяців тому
Optimizing Your Excel Calendar: Dynamic Layouts, Status Tracking, and More
Excel VBA Tutorial: Filtering Results Based on Search Text in a Textbox
Переглядів 469 місяців тому
Excel VBA Tutorial: Filtering Results Based on Search Text in a Textbox
Creating Outlook Appointments with Custom Templates Using VBA Macros
Переглядів 2709 місяців тому
Creating Outlook Appointments with Custom Templates Using VBA Macros
Effortless Data Import in Excel with Modern UI Buttons | Excel VBA Tutorial
Переглядів 769 місяців тому
Effortless Data Import in Excel with Modern UI Buttons | Excel VBA Tutorial
Creating Custom RibbonX Tabs and Buttons for Macro-Enabled Files
Переглядів 2129 місяців тому
Creating Custom RibbonX Tabs and Buttons for Macro-Enabled Files
Modern UI v1.0 - Find and Replace Tool for Microsoft Word
Переглядів 229 місяців тому
Modern UI v1.0 - Find and Replace Tool for Microsoft Word
Excel VBA Tutorial: Create a Dynamic Calendar and Generate PDFs with Macros
Переглядів 429 місяців тому
Excel VBA Tutorial: Create a Dynamic Calendar and Generate PDFs with Macros

КОМЕНТАРІ

  • @omarkammoun8841
    @omarkammoun8841 Місяць тому

    Hello @VBA by MBA Thank you so much for this presentation. COuld please share the script to test for my data?

  • @deiremigio1410
    @deiremigio1410 Місяць тому

    Hi, i have followed all the steps shown in the video but still unable to add a bullet although the insert bullets and numbering options are enabled on the menu above. Please can you help?

    • @VBAbyMBA
      @VBAbyMBA Місяць тому

      Thanks for asking, and I apologize for the late response. there are couple of reasons: 1. you should be using Rich Text Content controls NOT simple 2. you cannot add bullet on the first line of the content control. so you need to add a blank paragraph then add bullets. let me know if this helps? Regards, MBA

  • @haroldv730
    @haroldv730 3 місяці тому

    😋 'promosm'

  • @duanej.wallaceii373
    @duanej.wallaceii373 4 місяці тому

    USA

  • @francescovergentini3244
    @francescovergentini3244 4 місяці тому

    Can you share the VBA code?

    • @VBAbyMBA
      @VBAbyMBA 4 місяці тому

      Similar concept of sending and getting a request is applied here: drive.google.com/file/d/1PDrrfhlmk6Tqonvjd9w0eNnjbjjCeuoX/view?usp=sharing this code need modification to your needs, you can take the ideas from it. the UI shown in the Video is complex and the code cannot be shared

  • @mengmakara9365
    @mengmakara9365 4 місяці тому

    Nice

  • @ammaiappanm6920
    @ammaiappanm6920 6 місяців тому

    Blur

  • @barryneilson2135
    @barryneilson2135 10 місяців тому

    This is a macro that does absolutely nothing. The video is incomplete, with portions cut off in the VBE. Perhaps consider reviewing your video before uploading if your mission was to provide information.

    • @VBAbyMBA
      @VBAbyMBA 10 місяців тому

      Thank you so much for your opinion, I can provide the full VBA macro if you request. Purpose of this video is to show you guys the power of VBA as well as the limitations and scope. In this video I try to show how we can parse HTML and translate into word document.

  • @lindseyflannery2509
    @lindseyflannery2509 11 місяців тому

    Promo'SM 😒

  • @autnuncautnumquam
    @autnuncautnumquam 11 місяців тому

    Great work! Highly interested in a tutorial!

    • @VBAbyMBA
      @VBAbyMBA 11 місяців тому

      Glad you liked it!

  • @autnuncautnumquam
    @autnuncautnumquam 11 місяців тому

    Would you create a tutorial for this type of work?

    • @VBAbyMBA
      @VBAbyMBA 11 місяців тому

      Hi! thanks for asking. this one is an old project, I have been developing more like this, you can check my recent uploads. I do not have enough time to make big tutorials, i.e 20 min or so, but I try my best to make an attempt. - For your curiosity I am sharing the test file so that you can take a look at the version 10.0 (June 2022): drive.google.com/file/d/1jVNaxBprIh06FMk7iFaExH4kgmTlSwKi/view?usp=sharing

    • @autnuncautnumquam
      @autnuncautnumquam 11 місяців тому

      @@VBAbyMBA cool, very nice! Will look into your other work

  • @user-vu9pu6jb9c
    @user-vu9pu6jb9c Рік тому

    please share the vba code??

    • @VBAbyMBA
      @VBAbyMBA Рік тому

      you need to install third party tool OR a dll before using the code: I am sharing the excel file: drive.google.com/file/d/12GP12Hx3pASWvhifNhMBSGwOb7oIl7Nj/view?usp=sharing

    • @miki_5914
      @miki_5914 Місяць тому

      ​@@VBAbyMBAwhat third party tools did you use?

    • @VBAbyMBA
      @VBAbyMBA Місяць тому

      @@miki_5914 Please follow: www.codeproject.com/Tips/992992/VBA-Excel-Word-to-PDF-Encrypted-Password-Protected

  • @kancharlasan9294
    @kancharlasan9294 Рік тому

    Sir. Thnq for the input. So if i have to click the button using vba. How can i do it sir. help me

    • @VBAbyMBA
      @VBAbyMBA Рік тому

      What do you need to do after the click of a button? it will certainly be a macro trigger, so you can just call that macro anyway

  • @victorwestmann
    @victorwestmann Рік тому

    Oh boy you just saved me 8h of work. You were sent to me by the heavens! Do you know someone that could explain to me the VBA code line by line? But this is already great work! Thank you so much for this man!

    • @VBAbyMBA
      @VBAbyMBA Рік тому

      I record next video, and explain each line. I'm sure you will be curious

  • @krissosful
    @krissosful Рік тому

    Wow, awesome job!! Thank you very much for sharing this trick👏👏

    • @VBAbyMBA
      @VBAbyMBA Рік тому

      You are welcome 🙂

  • @My7starq
    @My7starq Рік тому

    please send code

    • @VBAbyMBA
      @VBAbyMBA Рік тому

      Hi Rudra! Thanks for showing your interest, this is quite lengthy needs thorough understanding, I will share the file with you so that you can have experience it

    • @voquocdat2k8
      @voquocdat2k8 9 місяців тому

      @@VBAbyMBA I don't know where you can share this file

    • @VBAbyMBA
      @VBAbyMBA 9 місяців тому

      how about doing it with labels instead of buttons? You just need few event handler like mouse-move on label: - set the label backstyle property to opaque mouse-move on User-form: - set the label backstyle property to transparent Now change your backcolor to one that should be shown when the mouse move on. @@voquocdat2k8

    • @naveednak2ali211
      @naveednak2ali211 День тому

      Sir can make complete tutorial on this topic can you share code or file.

  • @hasanmougharbel8030
    @hasanmougharbel8030 Рік тому

    Hey there, glad to discover your channel. I have a simple enquiry regarding my outlook application. I tried to enter my email and password in aim to open my account on the outlook application installed on my pc. Unfortunately, a message pop up saying "an encrypted connection to your mail sever server is not available." How can i solve this problem given that i have an installation of microsoft office enterprise 2007 and the pc is already placed within a network inside a company. Thanks for assisting me with this.

    • @VBAbyMBA
      @VBAbyMBA Рік тому

      Thanks for supporting. Do you guys have two factor authentication? Then you have to do manually.

  • @Hasnainali-335
    @Hasnainali-335 Рік тому

    Great

  • @Hasnainali-335
    @Hasnainali-335 Рік тому

    Nice Information

  • @Hasnainali-335
    @Hasnainali-335 Рік тому

    Great 👍

  • @shyraz
    @shyraz Рік тому

    👍

  • @shyraz
    @shyraz 2 роки тому

    bhai power supply gai tumhari 😎

    • @VBAbyMBA
      @VBAbyMBA 2 роки тому

      Kb?😢 Mtlb lambi chuti

    • @shyraz
      @shyraz 2 роки тому

      @@VBAbyMBA nhi ajj repair hojaygi..

  • @majeedkhan0471
    @majeedkhan0471 2 роки тому

    Please share the VBA code

    • @VBAbyMBA
      @VBAbyMBA 2 роки тому

      Dear! you can inbox me on that page, with related details I will surly help you facebook.com/VBA-Macros-for-Word-Excel-413537909418715?_rdc=1&_rdr

  • @yersonchinchilla5592
    @yersonchinchilla5592 2 роки тому

    does the macro remain in excel

    • @VBAbyMBA
      @VBAbyMBA 2 роки тому

      Macro remain in the excel macro enable workbook

  • @yersonchinchilla5592
    @yersonchinchilla5592 2 роки тому

    do I need to do this every time I open excel??

  • @yersonchinchilla5592
    @yersonchinchilla5592 2 роки тому

    My salvation, i was all the day trying to find a way to do it, and then you came with this macro and solved all my problems.

  • @yersonchinchilla5592
    @yersonchinchilla5592 2 роки тому

    you are good Bro, thanks

  • @yersonchinchilla5592
    @yersonchinchilla5592 2 роки тому

    thanks a lot

    • @VBAbyMBA
      @VBAbyMBA 2 роки тому

      You are welcome

  • @muhammadfawwazkhan2389
    @muhammadfawwazkhan2389 3 роки тому

    Wow

  • @muhammadfawwazkhan2389
    @muhammadfawwazkhan2389 3 роки тому

    Nice

  • @ubaidhussain711
    @ubaidhussain711 3 роки тому

    bhai koi voice aur kuch intrested karo

    • @VBAbyMBA
      @VBAbyMBA 3 роки тому

      hn zror next Videos main koshish kronga

  • @M--Zia
    @M--Zia 3 роки тому

    Is Fiverr free?

    • @VBAbyMBA
      @VBAbyMBA 3 роки тому

      Yes Free to make an account and start earning But Fiverr will take 20% of the amount you earned.

    • @M--Zia
      @M--Zia 3 роки тому

      Ok @@VBAbyMBA

  • @M--Zia
    @M--Zia 3 роки тому

    Good

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    Nice 🙂👍

  • @shyraz
    @shyraz 3 роки тому

    ❤❤

  • @maneeshkoru7996
    @maneeshkoru7996 3 роки тому

    NICE VIDEO BRO YOU DID A GREAT JOB

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    Nice work

  • @muhammadfawwazkhan2389
    @muhammadfawwazkhan2389 3 роки тому

    Wow

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    Great 😊👍

  • @muhammadfawwazkhan2389
    @muhammadfawwazkhan2389 3 роки тому

    Nice

  • @muhammadfawwazkhan2389
    @muhammadfawwazkhan2389 3 роки тому

    Wow

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    😄😄

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    Nice 👍

  • @shyraz
    @shyraz 3 роки тому

    zaber10 sir G

    • @VBAbyMBA
      @VBAbyMBA 3 роки тому

      Thanks bhai jan Kabutr ur gy hain

    • @shyraz
      @shyraz 3 роки тому

      @@VBAbyMBA han main dekh leay hain 😂

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    Thumbnail 😄😄😄😄😄

    • @VBAbyMBA
      @VBAbyMBA 3 роки тому

      Thanks here is video of thumbnail photoshop tutorial ua-cam.com/video/hS8G9KtT3vA/v-deo.html

  • @shyraz
    @shyraz 3 роки тому

    Geo Shair ek wari ferrrr.... ayega ayega sher ayega dhareyga dhareyga sher dharey ga

    • @VBAbyMBA
      @VBAbyMBA 3 роки тому

      Meiyan dy nary wajan gy

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    Great work

  • @muhammadfawwazkhan2389
    @muhammadfawwazkhan2389 3 роки тому

    Wow great 👍🏻

  • @shyraz
    @shyraz 3 роки тому

    گاردش۔ ❤❤

    • @VBAbyMBA
      @VBAbyMBA 3 роки тому

      Comandaar Nasir Khan Jaan

  • @eyeshe5129
    @eyeshe5129 3 роки тому

    Wow amazing ❣️