I found this extremely Helpful. I am going for a new job and they asked if I knew macros after this session I feel confident that I can do this job to the fullest
💻Access 1,000+ Microsoft Excel video training tutorials covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE! JOIN TODAY TO ADVANCE YOUR EXCEL SKILLS 👉 www.myexcelonline.com/107-42.html
this is amazing thanks! I watched this video for 5min(with fast forwarding) and then went ahead to build a simple VBA macro for work! I thought it's gonna take me much longer...Awesome information, thanks!
Nice introduction to macros and VBA code. I understood the coding itself but I often had trouble understanding looping. Your explanation of the "do while" looping code was easy to understand and now I feel confident I could use it in a similar circumstance. Thanks !!
I have just found your site and this is exactly what I was looking for for sometime now. I consider myself an intermediate user of Excel but I want to improve my knowledge from a certified organisation such as yours. Please let me know if this online training offer is still in effect today. Thank you.
Hi, this is a good vba Page. I suggest these useful macros: Workbook route in title bar Workbook name in title bar Highlight active cell Highlight active row & column Color tabs - worksheets Uncolor tabs - worksheets Number to letters
Hi the Video was too informative all i wanna ask is that if i want to for eg add a month July to my worksheet and then copy the july and paste till the end of the range and then i use the same macro in the other excel sheet where the is longer than this worksheet what can i do in order to get the data till the end of the range of the new excel worksheet
Hi. Thanks for the question. Can you see the original range? If it ends in say Cell D50, just edit the D50 to the end of your new range (the cell with the end of where the July that you added is). If that doesn't answer your question, please respond in more detail.
The concepts are shown so very clearly. I would lie to learn about VBA coding and macros to develop automated dashboards. Could you please guide me. Thank you !
Hello, I want to watch this video once more before I sign up for the course. Please send me a link so I can download it and watch it. I'm 79 and it takes me longer to catch on to this stuff. Thank you for the great session. thanks, Jim
Hello, is this course still offer those bonuses mentioned? I'm interested, but I don't know if I will still get the same value for the course. Please let me know. Thanks!
New to macros and looking to export data from sheet 1 to sheet 2, but only pulling through certain columns, and changing the data in those columns when it lands in sheet 2. Any ideas?
What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?
Thanks for the question. Are you asking how you know a workbook has VBA? It should have a .xlsm extension with the m being for macro. You can upload it and share it in OneDrive or SharePoint. If Sharing, SharePoint may be better. Hope that helps!
Hey, please help in VBA Codes for the work, i have workbook with 2 sheet, data available in sheet1 and same header available in sheet2, and the code should work for it will match the header and pull the data from sheet 1and paste it in sheet2 as per the header matched. if you share the code it will help me more. thanks
Hi. Thanks for the question. That's a little more complicated that we could help with in a comment, but we have a consulting service that could help you. Please check out www.myexcelonline.com/microsoft-excel-consulting-services/
I find it best to try and write the logic longhand in comments within cells that I would like to see in my workbook. How do others visualize the processes that they envision for their workbooks?
Thats a great way of doing things Claude! Each person has their own unique way of doing things inside Excel so they can easily remember how to get to a result :)
Hi, what is the technic! when sheet 1 entry sheet was complete and recorded, applying to database worksheet sheet 2 to record all rows isn't work please assist.
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers". Sub ListPrinters() Dim prt As Printer For Each prt In Printers Debug.Print Printer.deviceName Next prt End Sub
Thank you so much for the video. It was really helpful. I have a question, to ask you. If I have to copy a set of cells every day from a set of worksheets into a notepad and save that notepad datewise, is it possible to use macros or VBA? Please help.
Hi Abhishek! You could create a Macro under the View ribbon. And you can run the macro by selecting Macro|Run Macro. The macro IS VBA code. You could use it for things that aren't possible to do with a formula, like looping through cells until yo find a certain value or for processes you would do over and over again to automate them. It's a great language because it's not a hard one to learn. Check out our blog for more at www.myexcelonline.com/blog/
Thanks for the video Can YOU please explain how to remain sheets using the VBA code when we want to rename each sheet a different name? I tried Activesheet.Name code after 1st sheet name but it gives error Do YOU guys have any video on that or anyone else can help?
Good Day sir, Hope you can help. We had an employee leave the company and he changed the passwords fo rthe VBA editor on all of our templates. He had taken most of our templates and removed the menu bars and ribbons. We cant even use the undo feature. is there a way to find the password or remove it at least?
Hi Colin. Yes there is a way. This video is actually on our list of one to make soon. It's a little involved, but you can do it. First, make a backup of your Excel workbook and save it to another folder just in case you make a mistake. Then work with either the iriginal file or the back up and do the following: 1. Change the extension of the protected worksheet: rename it from *.xlsx to *.zip. 2. Open the ZIP File, double-click the "xl" folder, and then open the "worksheets" folder. 3. In there, you can find the spreadsheets (in .xml format). 4. Open a sheet file in Notepad. Now search for the content:
Can I record a ctrl+replace. I want to be able to hit a button and it replaces all of this year (year inputed in a certain cell) with next year (year put in another cell) but ctrl replace doesn't seem to be able to take info from a certain cell
Hello, when I uploaded the excel file to OneDrive, the developer tab disappeared, and I could not enable developer tab for the excel file stored in OneDrive. Please help!
Hi. I would suggest opening Excel and right clicking on the ribbon and choosing Customize the Ribbon.... On the right side of the screen you should be able to check the Developer ribbon again. Please let us know if you have anymore questions!
Sir need your help about conditional formatting! I want to highlight the row whenever I type "QC" in that row, and not all the cells in that row, want to highlight only those cells in that row which are filled (not empty). please guide!
Hi. You can clock this link and hit the Download Now button and put in your email and we will email it to you. myexcelonline.lpages.co/youtube-formulas-webinar-workbook-downloads/
Here is what Microsoft says about adding worksheets: "Limits on Sheets in a workbook are Limited by available memory (default is 1 sheet)". Are you having trouble adding more sheets to your workbook?
Hi. Thanks for watching! I would recommend downloading the sample workbook and comparing it to what you have written, as VBA needs to be exact. Or you can go back over the video and double check every line to see that it matches yours. The link to download it is in the description. Hope that helps!
Dear Sir, Want transfer data from one workbook to another. Workbook - A 1. Receipt No. 2. Date 3. Name 4. Amount To Workbook - B in two different Sheets can you please help to write correct VBA code.
Hi. You could select everything in one sheet by clicking the square between the Column A and the Row 1. That will select the whole sheet. Then you can copy everything that is selected in Worksheet A and paste it into the new sheets. Does that answer your question?
Sir Assume, we have columns emp code, name, date and attendance from 1 to 31. How to clear cells as per the date updated in column number 3. If i put date as 4th march 2021, I need the cells as blank from columns 5th March to 31st March. If it is possible, pls help..
I found this extremely Helpful. I am going for a new job and they asked if I knew macros after this session I feel confident that I can do this job to the fullest
WOW that is awesome Holley! Let us know how you get on with the job interview and I am sure that you will do well :)
💻Access 1,000+ Microsoft Excel video training tutorials covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE! JOIN TODAY TO ADVANCE YOUR EXCEL SKILLS 👉 www.myexcelonline.com/107-42.html
jump straight to 4:10 to skip the orga stuff at the beginning. Great Video. Thanks a mil.
4:24 to be exact but thanks!
Hey Jamal, Glad you liked this Excel Macros & VBA tutorial!
Been trying to learn VBA from RUclips. Watched tons of videos but this one actually was awesome. Thank you ❤️
That's great! Thanks for the positive feedback!
I used to hate coding before, Aftr watching this detailed explanation I started liking coding ,hope I can master in VBA
Practice makes perfect Rachel, keep on Excelling!
I think It’s not easy to simplify this , but you did it so well. Thank you very much.
You are welcome
5:46
this is amazing thanks! I watched this video for 5min(with fast forwarding) and then went ahead to build a simple VBA macro for work! I thought it's gonna take me much longer...Awesome information, thanks!
Hey FW, Glad you liked this Excel Macros & VBA tutorial!
Sir can u help me I have one file that I need different format to make macro ....plz hlp me sir
the way you teach makes it so easy to understand , thank you .
You are welcome! Thanks for the compliment!
1st time looking into Macros. Wasn't sure which video to start with. Glad I started with the right one! Excellent work! Thank you.
Glad it was helpful!
Hi ,I went though a lot of video in you tube and found your explanation is very simplest way, Thank you Kyle.
Oh, thank you! We try hard to make videos easy for everyone to understand.
Thank you John & Kyle. It was really amazing; Mr. Kyle did an awesome introduction to Macros and VBA. God bless you both.
Glad you enjoyed it!
5:37
This guy is an AWESOME TEACHER!
Thank you!
Wow! one of the clearest explanations of VBA code. Thanks a lot
Glad it was helpful! Thanks for watching.
Nice personality , clear and professional.
So nice of you. Thanks!
I like this so much and it's one of my best videos on youtube
That's great! Thanks so much!
Nice introduction to macros and VBA code. I understood the coding itself but I often had trouble understanding looping. Your explanation of the "do while" looping code was easy to understand and now I feel confident I could use it in a similar circumstance. Thanks !!
We are glad that you were able to learn the "do while" looping and become more confident in Excel VBA!
5:25
very nice and much helpful in learning VB macros. Thank you so much..
Most welcome! Thanks for watching!
I have just found your site and this is exactly what I was looking for for sometime now. I consider myself an intermediate user of Excel but I want to improve my knowledge from a certified organisation such as yours. Please let me know if this online training offer is still in effect today. Thank you.
Sure! Check out our website at myexcelonline.com as we have many different options under the Courses menu. Hope you find one helpful to you!
Hi, this is a good vba Page.
I suggest these useful macros:
Workbook route in title bar
Workbook name in title bar
Highlight active cell
Highlight active row & column
Color tabs - worksheets
Uncolor tabs - worksheets
Number to letters
Thanks for the tips! Those ARE good macros.
And check out our site for more macros: www.myexcelonline.com/137-42.html
clear so professional and awesome - great job bro.
Thank you!
Great Job Buddy . Extremely helpful..
Glad to hear it!
really thanks to god..i ve seen a lot video but your video i can understand very much better..really love u a lot a lot..big thumbs up from malaysia
You are most welcome and glad you learned how to use Macros & VBA to automate your Excel worksheets & reports!
Nice content . Nice presentation with clear workable english. Excellent trainer & his knowledge..
Glad you liked it
Wow, I never thought I would get excited about coding but this is really cool.
Welcome to the exciting world of coding Roger :)
Why didnt i find you guys earlier.... Blessing in disguise... I learnt so much from your channel and amazing training video... Totally nerdy ;)
That’s awesome to hear VC! Feel free to share our channel with your friends 👍
thanks dude, now monthly work, will finish in 1 day
It’s possible with Macros & VBA!!!
Such a simple and professional way to understand Macros, you're awesome guys. BEST Luck to you :)
Thanks for your comment and feel free to share this with your friends and colleagues :)
Thanks for the knowledge shared....
Our pleasure! Glad you liked it!
EASY ....ITS FLOWS ... YOUB ARE INDEED AN EXCEL TEACHING ANGEL
Thank you for your nice comments Idowu!
This is gold. very helpful thank you
You are welcome Chris and make sure to check out our other awesome Excel tutorials on our RUclips channel and over at www.myexcelonline.com/blog/
This is really good info. Thanks!
Thank YOU for letting us know!
I really liked this presentation easy to follow through
Glad you liked it.
Man you are the best thank you for your efforts!
My pleasure! So glad you found this helpful!
Thanks you are good at it
Thanks! Glad you liked it!
Excellent course. Very clear and organized.
Thanks Karen and I hope that Macros & VBA are much easier to you now!
Good video, and I recommend watching at 1.25x speed.
Thanks for your feedback and that is a great tip!
1.5 is fine too. I was dying... Thanks for the tip.
Thank you for the tips,
I'm watching at 2x and it's fine now
You are a great teacher. Thanks for the training
I hope you learned a lot of new Excel & VBA tips!
Nice video, I have learned new knowledge from the webinar. But the thing, this is only an introduction. lol
Great! Glad you now want to learn more. Check out our website and blog at www.myexcelonline.com/blog/ to learn even more!
Awesome ! Your former student Kyle !!
Hi Kyle! Glad to see you are still using Excel! Thanks for responding!
This is excellent material! Do you have the part 2 of this course on youtube please??
Hey Sitara, we have more VBA tutorials over at our Academy online course here: www.myexcelonline.com/academy/enroll-eg/
Amazing teaching
Thank you!
Hi John,
I would like to learn VBA macros more. Could you please share us more videos which is help us to learn VBA in depth.
Here we have 101 Macros for you: www.myexcelonline.com/blog/101-excel-macros-examples/
don't really know the magic was there in the excel .Thanks a lot to let me know..really appreciate the video
You are very welcome. Excel IS magical! And really fun to use!
You guys are GREAAAAAAAAAAAAAT
Thanks!
A wowsome webinar!
Glad you enjoyed this Excel Macros & VBA tutorial Sandeep! Feel free to share with your friends :)
Cheers,
John
so wonderful to follow to master VBA and Macros
You are welcome Moses!
Hi the Video was too informative all i wanna ask is that if i want to for eg add a month July to my worksheet and then copy the july and paste till the end of the range and then i use the same macro in the other excel sheet where the is longer than this worksheet what can i do in order to get the data till the end of the range of the new excel worksheet
Hi. Thanks for the question. Can you see the original range? If it ends in say Cell D50, just edit the D50 to the end of your new range (the cell with the end of where the July that you added is). If that doesn't answer your question, please respond in more detail.
Well done Kyle, thanks!
Glad you enjoyed this Brenda!
Cheers,
John
Hi
Loved it!!!!!
I am glad you enjoyed our Macros & VBA tutorial Thato!
Thanks , Love this video
Im glad you enjoyed this Macros & VBA tutorial Siafa :)
It's extremely helpfull. If you show me how we can assign any job into among some employees by using vba. It will be more helpful for me
Hi! Thanks for the feedback. Check our blog at www.myexcelonline.com/blog
The concepts are shown so very clearly. I would lie to learn about VBA coding and macros to develop automated dashboards. Could you please guide me. Thank you !
We have a dashboard series AND a VBA series if you'd like to check them out.
ruclips.net/video/V6bLATFw4Vw/видео.html
Also, there's an intro to dashboards in this playlist, towards the bottom: ruclips.net/video/vA2NiYiGkgs/видео.html
And if you don't find what you need there, please check out our blog: www.myexcelonline.com/blog/
Wow! that's great
Thank you! Cheers!
Thank you do much!
You're welcome!
Hello, I want to watch this video once more before I sign up for the course. Please send me a link so I can download it and watch it. I'm 79 and it takes me longer to catch on to this stuff. Thank you for the great session.
thanks,
Jim
Hey Jim, unfortunate the video is not downloadable but you can watch it as many times as you like here 😀
Thanks for the informatory videos...well explained :)
You are welcome 🙏
Beautiful. Thank you.
Our pleasure!
Hello, is this course still offer those bonuses mentioned? I'm interested, but I don't know if I will still get the same value for the course. Please let me know. Thanks!
Hey Janet yes it does! Just go to our website myexcelonline.com and drop us an email there. We will get you setup asap! 💚
Thank you indeed for this video, very helpful.
I'm glad you enjoyed this Macros & VBA tutorial Mauricio!
Thank you so much.
You are welcome
This is very useful, clear and very precise. Do you have other tutorials like this either in Python, R, Data Science, Data Analytics, ML, or SQL
Unfortunately we don’t have those specific courses at the moment
Thanks you very much blue men!
🎶im blue if i was green i was die🎶
HAHA! Thanks for watching.
This was a great webinar for introduction on Macros and VBA.
Obviously no one can master it in 1hour, if that was the case everyone would 😂
You are correct! Hopefully it was enough to get you interested in VBA.
Dr Manhattan is teaching us Macros/VBA
😃
Very helpful, but definitely watch at 1.25x speed, otherwise it's gonna be a long watch
Good tip!
New to macros and looking to export data from sheet 1 to sheet 2, but only pulling through certain columns, and changing the data in those columns when it lands in sheet 2. Any ideas?
It might be better for you to use Power Query, as PQ is perfect for data transformations.
If anyone know other Kyle's tutorials pls make a list
Hi. Yes, we have a complete set of Kyle's tutorials here: join.myexcelonline.com/
What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?
Thanks for the question. Are you asking how you know a workbook has VBA? It should have a .xlsm extension with the m being for macro. You can upload it and share it in OneDrive or SharePoint. If Sharing, SharePoint may be better. Hope that helps!
This is awesome!
Glad you enjoyed this Excel Macros & VBA tutorial for beginners!
Cheers,
John
Hey, please help in VBA Codes for the work, i have workbook with 2 sheet, data available in sheet1 and same header available in sheet2, and the code should work for it will match the header and pull the data from sheet 1and paste it in sheet2 as per the header matched. if you share the code it will help me more. thanks
Hi. Thanks for the question. That's a little more complicated that we could help with in a comment, but we have a consulting service that could help you. Please check out www.myexcelonline.com/microsoft-excel-consulting-services/
I find it best to try and write the logic longhand in comments within cells that I would like to see in my workbook. How do others visualize the processes that they envision for their workbooks?
Thats a great way of doing things Claude! Each person has their own unique way of doing things inside Excel so they can easily remember how to get to a result :)
This ìs really greàt
Thank you!
Hi, what is the technic! when sheet 1 entry sheet was complete and recorded, applying to database worksheet sheet 2 to record all rows isn't work please assist.
Hi. Thanks for the question. Could you please let us know the timestamp in the video where you are having issues? Thank you.
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers".
Sub ListPrinters()
Dim prt As Printer
For Each prt In Printers
Debug.Print Printer.deviceName
Next prt
End Sub
Go to Tools -> References and make sure that Microsoft Access Object Library is checked.
thank you for this!!
You are most welcome Nasta!
Thank you so much for the video. It was really helpful. I have a question, to ask you.
If I have to copy a set of cells every day from a set of worksheets into a notepad and save that notepad datewise, is it possible to use macros or VBA? Please help.
You can create a filesystemobject and use the CreateTextFile method. Also, visit our blog for lots of tips: www.myexcelonline.com/blog/
I have 2 questions.
1. How to define live month in in excel macro?
2. How to create dynamic filter?
you can use the MONTH function to get the current month. Check our blog for more info: www.myexcelonline.com/blog/
Hi I am Abhishek from India I want to learn VBA Coding but it's looks difficult to learn Coding how I would learn these code ?
Hi Abhishek! You could create a Macro under the View ribbon. And you can run the macro by selecting Macro|Run Macro. The macro IS VBA code. You could use it for things that aren't possible to do with a formula, like looping through cells until yo find a certain value or for processes you would do over and over again to automate them. It's a great language because it's not a hard one to learn. Check out our blog for more at www.myexcelonline.com/blog/
thanks! Loud and clear
You're welcome!
Useful
Glad to hear that Mariann!
kyle you ROCK!
Glad you enjoyed this Excel Macros & VBA tutorial for beginners!
Cheers,
John
Mom: So what'd you do today?
Me: Learned Macros from the blue man
Mom: What did we say about lying?
Me: Mom(1).Delete
I don’t get it. Be back in 1:22:26
😃
Hi how wpuld you find the percentage of two sheets in macro
Hi. Thanks for writing! Could you please clarify what percentage you would like?
Thanks for the video
Can YOU please explain how to remain sheets using the VBA code when we want to rename each sheet a different name?
I tried Activesheet.Name code after 1st sheet name but it gives error
Do YOU guys have any video on that or anyone else can help?
Hi Wasay. Do you have a copy of the code you are trying? Sometimes it is found in Worksheets("name of sheet") . You can try that.
Good Day sir,
Hope you can help. We had an employee leave the company and he changed the passwords fo rthe VBA editor on all of our templates. He had taken most of our templates and removed the menu bars and ribbons. We cant even use the undo feature. is there a way to find the password or remove it at least?
Hi Colin. Yes there is a way. This video is actually on our list of one to make soon. It's a little involved, but you can do it.
First, make a backup of your Excel workbook and save it to another folder just in case you make a mistake. Then work with either the iriginal file or the back up and do the following:
1. Change the extension of the protected worksheet: rename it from *.xlsx to *.zip.
2. Open the ZIP File, double-click the "xl" folder, and then open the "worksheets" folder.
3. In there, you can find the spreadsheets (in .xml format).
4. Open a sheet file in Notepad. Now search for the content:
Please is VBA and MACROS needed for Accountants or Financial analysts?
Yes, using alot
There are a lot of great functions for Financials in Excel, but as in all things, VBA allows you to do even more.
nice
Thanks
Can I record a ctrl+replace. I want to be able to hit a button and it replaces all of this year (year inputed in a certain cell) with next year (year put in another cell) but ctrl replace doesn't seem to be able to take info from a certain cell
Thanks for the question. CTRL+F will help you to get to replace dialog box.
Yes, but I want to add it to a macro, if possible@@MyExcelOnline
Are you asking if CTRL+F can be used to run a macro? No because it is already reserved. You may be able to use CTRL+SHIFT+F.
Hello, when I uploaded the excel file to OneDrive, the developer tab disappeared, and I could not enable developer tab for the excel file stored in OneDrive. Please help!
Hi. I would suggest opening Excel and right clicking on the ribbon and choosing Customize the Ribbon.... On the right side of the screen you should be able to check the Developer ribbon again. Please let us know if you have anymore questions!
so nice
Glad you liked this Excel Macros & VBA tutorial!
Hi, I have a question: How can I create a dynamic pyramid chart that is horizontally and vertically segmented? In excel or power BI. Thanks a million.
Please check our blog and if you don't find the answer, feel free to contact us there. www.myexcelonline.com/blog/
I want to create new macro to replace given path to other tab as input given through macro
Please check out our blog for more info: www.myexcelonline.com/blog/
Sir need your help about conditional formatting!
I want to highlight the row whenever I type "QC" in that row, and not all the cells in that row, want to highlight only those cells in that row which are filled (not empty).
please guide!
Please look at this tutorial which will help you out: www.myexcelonline.com/blog/conditional-format-a-cells-value/
Hello sir,
The file is not downloading... I tried multiple times...
Hi. You can clock this link and hit the Download Now button and put in your email and we will email it to you.
myexcelonline.lpages.co/youtube-formulas-webinar-workbook-downloads/
i have a excel file having 21 sheets using micros. need to add more sheets
Here is what Microsoft says about adding worksheets: "Limits on Sheets in a workbook are Limited by available memory (default is 1 sheet)". Are you having trouble adding more sheets to your workbook?
when you are creating a macro to copy and paste value into another sheet, can you copy down or do you have to only go right to left?
You can copy whichever direction you like
I followed the VBA for adding sheets inside of sheets and kept getting a bug error.
Hi. Thanks for watching! I would recommend downloading the sample workbook and comparing it to what you have written, as VBA needs to be exact. Or you can go back over the video and double check every line to see that it matches yours. The link to download it is in the description. Hope that helps!
Dear Sir,
Want transfer data from one workbook to another.
Workbook - A
1. Receipt No.
2. Date
3. Name
4. Amount
To Workbook - B in two different Sheets
can you please help to write correct VBA code.
Hi. You could select everything in one sheet by clicking the square between the Column A and the Row 1. That will select the whole sheet. Then you can copy everything that is selected in Worksheet A and paste it into the new sheets. Does that answer your question?
@@MyExcelOnline Thanks for your reply, but I want to transfer some to particular items only to the another workbook
Sir
Assume, we have columns emp code, name, date and attendance from 1 to 31. How to clear cells as per the date updated in column number 3. If i put date as 4th march 2021, I need the cells as blank from columns 5th March to 31st March. If it is possible, pls help..
Please check out our Blog here for the answer: www.myexcelonline.com/blog/
Hi need your help,
Can we use VBA code in shared mail box
Hi Prasenjit. Do you mean in Microsoft Outlook? If so, yes, VBA can be used there as well as in most Office products (Access, Word, Excel).