Useful Excel and VBA References

BittenApple
BronzeLounger
Posts: 1234
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: 1234
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: 1234
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: 25167
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: 1234
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: 25167
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
UraniumLounger
Posts: 6270
Joined: 25 Jan 2010, 09:09
Location: up North (but it's not that grim)

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: 25167
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: 1228
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 have had my fill of hearing about death recently. I have decide to live for ever, or at least to die in the attempt :heavy:

BilasTasol
NewLounger
Posts: 20
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: 69458
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;
Regards,
Hans

BilasTasol
NewLounger
Posts: 20
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;