Useful Excel and VBA References
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Useful Excel and VBA References
Rudi and others,
This is a real treasure for us.
Thanks,
This is a real treasure for us.
Thanks,
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Useful Excel and VBA References
Rudi,
Thanks for all these references.
They are so valuable!!!
Regards,
BittenApple
Thanks for all these references.
They are so valuable!!!
Regards,
BittenApple
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Useful Excel and VBA References
I found Excel Macro Mastery very useful as well!
BittenApple
BittenApple
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Useful Excel and VBA References
The thread is old, so I'm glad to see that many of the references are still valid.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Useful Excel and VBA References
Rudi,
Everything here in this forum are often visited for a reference and review; they are very valuable for us and they never get old even if the link is changed.
BittenApple
Everything here in this forum are often visited for a reference and review; they are very valuable for us and they never get old even if the link is changed.
BittenApple
-
- 3StarLounger
- Posts: 357
- Joined: 02 Jun 2013, 05:55
- Location: Australia - SOUTH MORANG - A northern suburb of the city of MELBOURNE in the state of Victoria
Re: Useful Excel and VBA References
Just found this https://exceloffthegrid.com/vba-code-snippets/
George
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Useful Excel and VBA References
Nice find geecee.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 357
- Joined: 02 Jun 2013, 05:55
- Location: Australia - SOUTH MORANG - A northern suburb of the city of MELBOURNE in the state of Victoria
Re: Useful Excel and VBA References
Thanks Rudi.Rudi wrote:Nice find geecee.
George
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
-
- Panoramic Lounger
- Posts: 8490
- Joined: 25 Jan 2010, 09:09
- Location: retirement
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Useful Excel and VBA References
....which tells me it's time for
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- BronzeLounger
- Posts: 1499
- Joined: 28 Feb 2015, 13:11
- Location: Hof, Bayern, Germany
Immediate Window is a must for VBA work, IMO
Debugging Immediate Window Watch Window F8 Debug (Break) Mode
I don’t often recommend Blogs, as I like to try and explain things every time myself, … but I found this one Blog particularly clear, concise , easy to read, and extremely useful.I think it should be on every beginners reading list.
I would strongly recommend anyone learning VBA or using VBA to take the time to read this:
https://www.excelcampus.com/vba/vba-imm ... dow-excel/" onclick="window.open(this.href);return false;
In my opinion it is a false economy not to get familiar with the Immediate Window and use of it in debugging a code. If you are not familiar with it, then you will likely get your time investment back with the time you save the first time you use it when anything goes wrong in any coding. It is an essential part of your tool box: compare it to your Multimeter and Oscilloscope when trying to repair any Electrical device: Without that and some other debug stuff** you are blind
**A few debug tips I would add to that Blog, based on my experience, in the text file attached
Alan
Ref
https://www.excelforum.com/excel-progra ... ost5174166" onclick="window.open(this.href);return false;
You do not have the required permissions to view the files attached to this post.
I am having difficulty logging in with this account just now.
You can find me at DocAElstein also
You can find me at DocAElstein also
-
- NewLounger
- Posts: 24
- Joined: 09 Feb 2010, 17:25
- Location: Rhondda Cynon Taff, S. Wales
Re: Useful Excel and VBA References
May I add the Wise Owl Tutorials on YouTube - full of helpful guidance, and very well presented.
-
- Administrator
- Posts: 79539
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Useful Excel and VBA References
Thanks, long time no see!
Link: https://www.youtube.com/user/WiseOwlTutorials" onclick="window.open(this.href);return false;
Link: https://www.youtube.com/user/WiseOwlTutorials" onclick="window.open(this.href);return false;
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 24
- Joined: 09 Feb 2010, 17:25
- Location: Rhondda Cynon Taff, S. Wales
Re: Useful Excel and VBA References
Hi Hans:
Yes, ages since I contributed, but I've been lurking, though!
Thanks for adding the correct link.
Yes, ages since I contributed, but I've been lurking, though!
Thanks for adding the correct link.
-
- NewLounger
- Posts: 1
- Joined: 25 Aug 2023, 10:29
Re: Useful Excel and VBA References
OfficeTuts is a comprehensive tutorial site designed to teach users the basic and advanced features of Microsoft Excel. With richly illustrated lessons and examples, users can learn everything from navigating the interface to advanced formulas and VBA techniques. Topics covered include data entry and editing, formatting, data analysis, charts, pivot tables, VBA programming, and more. Whether you're a beginner or an experienced user, Excel Tutorials has resources to help you excel in Excel.