Useful Excel and VBA References

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Useful Excel and VBA References

Post by BittenApple »

Rudi and others,
This is a real treasure for us.
Thanks,
:thankyou: :thankyou: :fanfare: :clapping:

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Useful Excel and VBA References

Post by BittenApple »

Rudi,
Thanks for all these references.
They are so valuable!!!
Regards,
BittenApple

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Useful Excel and VBA References

Post by BittenApple »

I found Excel Macro Mastery very useful as well!
BittenApple

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Useful Excel and VBA References

Post by Rudi »

The thread is old, so I'm glad to see that many of the references are still valid. :thumbup:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Useful Excel and VBA References

Post by BittenApple »

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

User avatar
geecee
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

Post by 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!)

:smile: Don't cry because it's over...Smile because it happened.l :smile:

:note: At the end of the day it's midnight. :note:


User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Useful Excel and VBA References

Post by Rudi »

Nice find geecee. :thumbup:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
geecee
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

Post by geecee »

Rudi wrote:Nice find geecee. :thumbup:
Thanks Rudi.
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!)

:smile: Don't cry because it's over...Smile because it happened.l :smile:

:note: At the end of the day it's midnight. :note:


User avatar
stuck
Panoramic Lounger
Posts: 8125
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: Useful Excel and VBA References

Post by stuck »

geecee wrote:Just found this...
and it led me to this.

:laugh:

Ken

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Useful Excel and VBA References

Post by Rudi »

....which tells me it's time for :coffeetime:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
Doc.AElstein
BronzeLounger
Posts: 1499
Joined: 28 Feb 2015, 13:11
Location: Hof, Bayern, Germany

Immediate Window is a must for VBA work, IMO

Post by Doc.AElstein »

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

BilasTasol
NewLounger
Posts: 24
Joined: 09 Feb 2010, 17:25
Location: Rhondda Cynon Taff, S. Wales

Re: Useful Excel and VBA References

Post by BilasTasol »

May I add the Wise Owl Tutorials on YouTube - full of helpful guidance, and very well presented.
Regards,

Tony.

http://www.sylviahugheswilliams.com" onclick="window.open(this.href);return false;

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Useful Excel and VBA References

Post by HansV »

Thanks, long time no see!

Link: https://www.youtube.com/user/WiseOwlTutorials" onclick="window.open(this.href);return false;
Best wishes,
Hans

BilasTasol
NewLounger
Posts: 24
Joined: 09 Feb 2010, 17:25
Location: Rhondda Cynon Taff, S. Wales

Re: Useful Excel and VBA References

Post by BilasTasol »

Hi Hans:
Yes, ages since I contributed, but I've been lurking, though!
Thanks for adding the correct link.
Regards,

Tony.

http://www.sylviahugheswilliams.com" onclick="window.open(this.href);return false;

sirDexter
NewLounger
Posts: 1
Joined: 25 Aug 2023, 10:29

Re: Useful Excel and VBA References

Post by sirDexter »

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.