Thanks for watching this video introduction to the VBA Editor for Excel. I hope you had fun learning how to make sheets visible, hidden and VERY hidden! You can get your free e-book and email course at the following link: DOWNLOAD EBOOK → launchexcel.lpages.co/first-macro-ebook Please do leave comments below with any questions you have about learning Macros and VBA for Excel. And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!
If it wasn't for you, I don't know if I would have ever given macros a try. I wrote my first macro because of you and am now interested in learning more about macros & VBA, and eventually mastering it.
very informative. very eagerly waiting for other videos. Thanks a lot for having taken the trouble in doing this great job. On behalf of all my Excel lovers/addicts/users I sincerely thank you.
deffo very useful. looking forward to more videos from you. can you show in one of your future videos how to update an excel workbook without entering it? i.e. at work i have to drag down on several sheets one line in order to update the current date and figures which are linked to that. ideally i want to run something which does that for all the workbooks automatically. i presume i have to create something like a batch file but maybe there is another method ? cheers
Hi Philipp Saul. Thanks for commenting and I do have more videos planned :) In terms of your current query if you want to read from and write to Excel workbooks without opening them at all, I think ADO is required - see support.microsoft.com/en-us/help/257819/how-to-use-ado-with-excel-data-from-visual-basic-or-vba and stackoverflow.com/questions/40766915/write-update-data-via-ado-to-closed-excel-workbook Another suggestion is to use Access as the database and read/write using ADO, see www.vbaexpress.com/forum/showthread.php?22628-Solved-Add-data-to-a-closed-workbook You can also open workbooks without making them visible to the user, see forums.devshed.com/visual-basic-programming-52/excel-vba-writing-data-closed-workbook-using-ado-329061.html
Hi Zack! Thanks for your comment. Sure I'm going to start making more videos about Macros and VBA. Let me know if there's any specific topic you want to learn about.
Hi CRO0320351 nishant arora! I split the screen using the standard Windows +left arrow / Windows +right arrow... in Windows 10 that automatically snaps the windows to left and right. There's a nice article on Windows10 Snap Assist here: www.cnet.com/how-to/how-to-use-windows-10s-new-snap-assist/ Also... I use Epic Pen for the onscreen writing. Very nice tool!'epic-pen.com/
Hi Meghraj, yes that can be done. There's a blog post by SumProduct (financial modelling group) that explains how to use Application.FindFormat to search for cell formatting, in combination with Range.Find. You can read it here: www.sumproduct.com/blog/article/vba-blogs/vba-blog-find-the-right-look Hope that helps to get you started. - Victor [Note: I'm not affiliated with SumProduct]
Yes it does work fine without holding ALT. however if you hold down ALT you can snap the button edges to the grid lines... which can be useful if you like alignment to other parts of the spreadsheet. Also works for other shapes in Excel as well as charts... thanks for the question! - Victor
Thanks for watching this video introduction to the VBA Editor for Excel. I hope you had fun learning how to make sheets visible, hidden and VERY hidden! You can get your free e-book and email course at the following link: DOWNLOAD EBOOK → launchexcel.lpages.co/first-macro-ebook
Please do leave comments below with any questions you have about learning Macros and VBA for Excel. And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!
If it wasn't for you, I don't know if I would have ever given macros a try. I wrote my first macro because of you and am now interested in learning more about macros & VBA, and eventually mastering it.
The best teacher EVER!
I'm so happy to hear this! Congrats on writing your first one and keep exploring-you’ll be mastering macros and VBA in no time.
Thanks Pal, great videos
very informative. very eagerly waiting for other videos. Thanks a lot for having taken the trouble in doing this great job. On behalf of all my Excel lovers/addicts/users I sincerely thank you.
Hi Gopala - it's my sincere desire to create more videos just like this for you!
thanks for another interesting video
deffo very useful. looking forward to more videos from you. can you show in one of your future videos how to update an excel workbook without entering it? i.e. at work i have to drag down on several sheets one line in order to update the current date and figures which are linked to that. ideally i want to run something which does that for all the workbooks automatically. i presume i have to create something like a batch file but maybe there is another method ? cheers
Hi Philipp Saul. Thanks for commenting and I do have more videos planned :)
In terms of your current query if you want to read from and write to Excel workbooks without opening them at all, I think ADO is required - see support.microsoft.com/en-us/help/257819/how-to-use-ado-with-excel-data-from-visual-basic-or-vba and stackoverflow.com/questions/40766915/write-update-data-via-ado-to-closed-excel-workbook
Another suggestion is to use Access as the database and read/write using ADO, see www.vbaexpress.com/forum/showthread.php?22628-Solved-Add-data-to-a-closed-workbook
You can also open workbooks without making them visible to the user, see forums.devshed.com/visual-basic-programming-52/excel-vba-writing-data-closed-workbook-using-ado-329061.html
I know its been almost a year, but are we getting more of these videos at some point? They're are so helpful to someone trying to learn macros and VBA
Hi Zack! Thanks for your comment. Sure I'm going to start making more videos about Macros and VBA. Let me know if there's any specific topic you want to learn about.
Hi Victor,
Very helpfull videoes
you are doing gud.
which software are you using to split screen?
Hi CRO0320351 nishant arora! I split the screen using the standard Windows +left arrow / Windows +right arrow... in Windows 10 that automatically snaps the windows to left and right. There's a nice article on Windows10 Snap Assist here: www.cnet.com/how-to/how-to-use-windows-10s-new-snap-assist/
Also... I use Epic Pen for the onscreen writing. Very nice tool!'epic-pen.com/
Hi Victor, I wanted Excel to find Colored text and ask me what to replace it with? Can this be done using macros?
Hi Meghraj, yes that can be done. There's a blog post by SumProduct (financial modelling group) that explains how to use Application.FindFormat to search for cell formatting, in combination with Range.Find.
You can read it here: www.sumproduct.com/blog/article/vba-blogs/vba-blog-find-the-right-look
Hope that helps to get you started.
- Victor
[Note: I'm not affiliated with SumProduct]
Why do u need to hold Alt key while drawing the button? It works just fine without holding.
Yes it does work fine without holding ALT. however if you hold down ALT you can snap the button edges to the grid lines... which can be useful if you like alignment to other parts of the spreadsheet. Also works for other shapes in Excel as well as charts... thanks for the question! - Victor