![VBA by MBA](/img/default-banner.jpg)
- 112
- 29 892
VBA by MBA
United States
Приєднався 3 кві 2009
Welcome to VBAbyMBA, the perfect destination for those looking to learn and have fun at the same time! Our channel provides exciting videos on various topics to help you make your life smarter and easier. We specialize in automation using VBA in MS Office, with a focus on MS Word, Excel, and Outlook. Our videos are informative and engaging, designed to teach you practical skills that you can apply in your daily life. Subscribe to VBAbyMBA for regular updates and join our community of learners today!
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 :)
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
Hello @VBA by MBA Thank you so much for this presentation. COuld please share the script to test for my data?
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?
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
😋 'promosm'
USA
Can you share the VBA code?
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
Nice
Thanks
Blur
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.
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.
Promo'SM 😒
Great work! Highly interested in a tutorial!
Glad you liked it!
Would you create a tutorial for this type of work?
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
@@VBAbyMBA cool, very nice! Will look into your other work
please share the vba code??
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
@@VBAbyMBAwhat third party tools did you use?
@@miki_5914 Please follow: www.codeproject.com/Tips/992992/VBA-Excel-Word-to-PDF-Encrypted-Password-Protected
Sir. Thnq for the input. So if i have to click the button using vba. How can i do it sir. help me
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
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!
I record next video, and explain each line. I'm sure you will be curious
Wow, awesome job!! Thank you very much for sharing this trick👏👏
You are welcome 🙂
please send code
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
@@VBAbyMBA I don't know where you can share this file
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
Sir can make complete tutorial on this topic can you share code or file.
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.
Thanks for supporting. Do you guys have two factor authentication? Then you have to do manually.
Great
Nice Information
Thanks
Great 👍
👍
bhai power supply gai tumhari 😎
Kb?😢 Mtlb lambi chuti
@@VBAbyMBA nhi ajj repair hojaygi..
Please share the VBA code
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
does the macro remain in excel
Macro remain in the excel macro enable workbook
do I need to do this every time I open excel??
Just one time
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.
you are good Bro, thanks
Welcome 👍
thanks a lot
You are welcome
Wow
Nice
bhai koi voice aur kuch intrested karo
hn zror next Videos main koshish kronga
Is Fiverr free?
Yes Free to make an account and start earning But Fiverr will take 20% of the amount you earned.
Ok @@VBAbyMBA
Good
Nice 🙂👍
Thanks alot
❤❤
💕✌️
NICE VIDEO BRO YOU DID A GREAT JOB
Thanks alot
Nice work
Wow
Thanks
Great 😊👍
Nice
Wow
Thanks
😄😄
😅
Nice 👍
zaber10 sir G
Thanks bhai jan Kabutr ur gy hain
@@VBAbyMBA han main dekh leay hain 😂
Thumbnail 😄😄😄😄😄
Thanks here is video of thumbnail photoshop tutorial ua-cam.com/video/hS8G9KtT3vA/v-deo.html
Geo Shair ek wari ferrrr.... ayega ayega sher ayega dhareyga dhareyga sher dharey ga
Meiyan dy nary wajan gy
Great work
Thanks a lot
Wow great 👍🏻
گاردش۔ ❤❤
Comandaar Nasir Khan Jaan
Wow amazing ❣️