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
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!
💻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
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.
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 !!
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
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 :)
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!
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.
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?
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/
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?
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
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.
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!
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
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!
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:
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!
On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box. A new Ribbon will appear and from here you can create a button and assign a macro to that button.
You can modify the code to include a list of your departments and then have the loop go through the list. You could create an ARRAY variable that holds all the department names and then loop through that. Something like this… Sub DeptWS() Dim depts(1 To 4) As String Dim i As Integer
My Excel file has with few cells having ||. how can I remove these characters using vba macro? example cell AC64 has 2020-07-24 17:00:00||2020-07-24 17:00:00 Any suggestions?
If you save your Excel sheet as a .csv, you can then go into Outlook and File|Open & Export||Import/Export and go to Import From Another Program. See if that helps you get started.
How can "i" stand for two things at once? i=1 and i=i+1. Is the first i a variable and the second a loop variable or something specific to the loop? I don't get it.
They’re the same variable. One of the benefits of working with variables is they can change their value as the procedure runs. In this case we initialize “i” to be equal to 1. But each time it loops we increase the current value of “i” by 1. You do have the option to create static variables that can’t change their value. But in this case we want the variable to be able to change.
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?
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..
Here is the code to "Attach your current workbook into an Outlook email message": Sub AttachWorkbookIntoEmailMessage() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0) 'Let us create the email message and display it 'Make sure to change the parameters below With OutlookMail .To = "support@myexcelonline.com" .Subject = "Have a look at this workbook" .Body = "Hey John, Could you help out on this?" .Attachments.Add ActiveWorkbook.FullName .Display End With Set OutlookMail = Nothing Set OutlookApp = Nothing End Sub
I have an issue. I had created my macro on VBA, afterwards I wanted to create a button, but the "Insert option" it is greyed out. I don't know what is going on if the Developer tab is available, Why does the Insert button is not? Please Help!!! I need to create a button to run my macro.
You can also use the button to Customize the Quick Access Toolbar at the top of the screen. Once you are in there, go to More Commands... Under Choose Commands From, select Macros. You can see a list of your macros from there and choose one to have a button on the Quick Access Toolbar. Hope that helps!
@@MyExcelOnline Thanks for answer my question. It didn't work in this way either. Do you have any other option I can use? I really had checked everything!!
Hi 😊 im a CS student. Its hard for me to Learn Visual Basic because i don't have a laptop or pc is there an vb app that i can use in mobile phone? Thanks ..
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 :)
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!
I think It’s not easy to simplify this , but you did it so well. Thank you very much.
You are welcome
5:46
Been trying to learn VBA from TH-cam. Watched tons of videos but this one actually was awesome. Thank you ❤️
That's great! Thanks for the positive feedback!
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 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
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!
This guy is an AWESOME TEACHER!
Thank you!
💻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
the way you teach makes it so easy to understand , thank you .
You are welcome! Thanks for the compliment!
I like this so much and it's one of my best videos on youtube
That's great! Thanks so much!
Wow! one of the clearest explanations of VBA code. Thanks a lot
Glad it was helpful! Thanks for watching.
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.
Nice personality , clear and professional.
So nice of you. Thanks!
Great Job Buddy . Extremely helpful..
Glad to hear it!
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 :)
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!
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
Wow, I never thought I would get excited about coding but this is really cool.
Welcome to the exciting world of coding Roger :)
clear so professional and awesome - great job bro.
Thank you!
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 👍
Nice content . Nice presentation with clear workable english. Excellent trainer & his knowledge..
Glad you liked it
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!
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!
very nice and much helpful in learning VB macros. Thank you so much..
Most welcome! Thanks for watching!
This is gold. very helpful thank you
You are welcome Chris and make sure to check out our other awesome Excel tutorials on our TH-cam channel and over at www.myexcelonline.com/blog/
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
EASY ....ITS FLOWS ... YOUB ARE INDEED AN EXCEL TEACHING ANGEL
Thank you for your nice comments Idowu!
thanks dude, now monthly work, will finish in 1 day
It’s possible with Macros & VBA!!!
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/
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.
A wowsome webinar!
Glad you enjoyed this Excel Macros & VBA tutorial Sandeep! Feel free to share with your friends :)
Cheers,
John
Man you are the best thank you for your efforts!
My pleasure! So glad you found this helpful!
You are a great teacher. Thanks for the training
I hope you learned a lot of new Excel & VBA tips!
I really liked this presentation easy to follow through
Glad you liked it.
This is really good info. Thanks!
Thank YOU for letting us know!
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/
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.
th-cam.com/video/V6bLATFw4Vw/w-d-xo.html
Also, there's an intro to dashboards in this playlist, towards the bottom: th-cam.com/video/vA2NiYiGkgs/w-d-xo.html
And if you don't find what you need there, please check out our blog: www.myexcelonline.com/blog/
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
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 :)
You guys are GREAAAAAAAAAAAAAT
Thanks!
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 😀
Thank you indeed for this video, very helpful.
I'm glad you enjoyed this Macros & VBA tutorial Mauricio!
Thanks for the knowledge shared....
Our pleasure! Glad you liked it!
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 :)
Amazing teaching
Thank you!
Thanks for the informatory videos...well explained :)
You are welcome 🙏
so wonderful to follow to master VBA and Macros
You are welcome Moses!
Thanks you are good at it
Thanks! Glad you liked it!
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 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/
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.
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/
Beautiful. Thank you.
Our pleasure!
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 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.
Thanks you very much blue men!
🎶im blue if i was green i was die🎶
HAHA! Thanks for watching.
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.
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.
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!
22:15
my title doesn't get changed why
I am not sure. For more information, please visit our blog at www.myexcelonline.com/blog/
Wow! that's great
Thank you! Cheers!
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.
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
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/
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!
This is awesome!
Glad you enjoyed this Excel Macros & VBA tutorial for beginners!
Cheers,
John
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/
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
Export image VBA macro in matlab of cst microwave studio
Is this what you need Preeti?
From cst microwave studio i nees
Is it possible to convert user dialog commands in VBA to normal commands
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?
Thank you so much.
You are welcome
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:
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!
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/
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!
kyle you ROCK!
Glad you enjoyed this Excel Macros & VBA tutorial for beginners!
Cheers,
John
how to apply macro recorded to another excel which have more rows compared to the recorded macro?
You'd have to adjust the row count in the VBA code. Can you provide some code here? Or visit our blog at www.myexcelonline.com/blog/
thank you for this!!
You are most welcome Nasta!
How do I assign a button to Clear the contents of specific cells on an excel template?
On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box. A new Ribbon will appear and from here you can create a button and assign a macro to that button.
how to change sheet name in VBA marco in stead of week 1 etc.... ,but give diffierent name ?
You can modify the code to include a list of your departments and then have the loop go through the list. You could create an ARRAY variable that holds all the department names and then loop through that. Something like this…
Sub DeptWS()
Dim depts(1 To 4) As String
Dim i As Integer
i = 1
depts(1) = "HR"
depts(2) = "IT"
depts(3) = "Sales"
depts(4) = "Training"
Do While i
@@MyExcelOnline you are awesome! Wonder what that example ⬆️ looks like after running macro?
My Excel file has with few cells having ||. how can I remove these characters using vba macro? example cell AC64 has 2020-07-24 17:00:00||2020-07-24 17:00:00
Any suggestions?
This tutorial explains this concept: www.myexcelonline.com/blog/remove-characters-at-the-start-using-macros-in-excel/
hi there, is it possible to download data from SAP into Excel using Excel VBA?
It is best to do this using Power BI Desktop to do that. Go to: Get Data > More > In the search box type in SAP.
hi, how do i send a bunch of calendar invites from excel to outlook
If you save your Excel sheet as a .csv, you can then go into Outlook and File|Open & Export||Import/Export and go to Import From Another Program. See if that helps you get started.
How can "i" stand for two things at once? i=1 and i=i+1. Is the first i a variable and the second a loop variable or something specific to the loop? I don't get it.
i=1 (First Instance) declares the value of i as 1. Then conditions are checked ie, 1
They’re the same variable. One of the benefits of working with variables is they can change their value as the procedure runs. In this case we initialize “i” to be equal to 1. But each time it loops we increase the current value of “i” by 1. You do have the option to create static variables that can’t change their value. But in this case we want the variable to be able to change.
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
😃
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?
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/
how many loops in the vba
However many you would like!
how and where to know that code like dim "i" adding of a worksheet?
Are you wanting to use code to add a worksheet? Dim i as Worksheet and then the next line would be Set i = ActiveWorkbook.Sheets.Add
Can i send Excel file through the outlook after my work completed with the help of macro
Here is the code to "Attach your current workbook into an Outlook email message":
Sub AttachWorkbookIntoEmailMessage()
Dim OutlookApp As Object
Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
'Let us create the email message and display it
'Make sure to change the parameters below
With OutlookMail .To = "support@myexcelonline.com" .Subject = "Have a look at this workbook" .Body = "Hey John, Could you help out on this?"
.Attachments.Add ActiveWorkbook.FullName
.Display
End With
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub
I have an issue. I had created my macro on VBA, afterwards I wanted to create a button, but the "Insert option" it is greyed out. I don't know what is going on if the Developer tab is available, Why does the Insert button is not? Please Help!!! I need to create a button to run my macro.
You can also use the button to Customize the Quick Access Toolbar at the top of the screen. Once you are in there, go to More Commands... Under Choose Commands From, select Macros. You can see a list of your macros from there and choose one to have a button on the Quick Access Toolbar. Hope that helps!
@@MyExcelOnline Thanks for answer my question. It didn't work in this way either. Do you have any other option I can use? I really had checked everything!!
Hi 😊 im a CS student. Its hard for me to Learn Visual Basic because i don't have a laptop or pc is there an vb app that i can use in mobile phone? Thanks ..
Hey Klaus, unfortunately I haven’t come across one but keep on searching and something may come up!
@@MyExcelOnline thanks
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.
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/