↓ Skip to Main Content
Useful code Programming with VBA, C# and Python

Main Navigation

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Useful code Programming with VBA, C# and Python

Off Canvas Menu

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About

Month: March 2021

Python – Class Variable vs Instance Variables

By Vitosh Posted on March 28, 2021 Posted in Python Tagged with Class Variable, Instance Variables, oop, Python
Python – Class Variable vs Instance Variables

Class variables vs instance variables could seem a bit strange, if you have no OOP experience, but after a few thausand lines of code they become logical. So, in around two days of programming you will be getting it intuitively …

Python – Class Variable vs Instance Variables Read more »

Python – Difference between __str__ and __repr__

By Vitosh Posted on March 21, 2021 Posted in Python Tagged with dunder, Python, repr, str
Python – Difference between __str__ and __repr__

__repr__  and __str__  dunders are quite similar in Python. If you need  a quick summary of these 2, then these 3 points will be enough: __repr__ dunder presents the class object, whenever it is called by the terminal __str__ dunder …

Python – Difference between __str__ and __repr__ Read more »

VBA – Make Excel Comments Beautiful

By Vitosh Posted on March 14, 2021 Posted in VBA \ Excel Tagged with edit comment, Excel, make comments float, unhide comments, VBA
VBA – Make Excel Comments Beautiful

Everyone, who has worked with Excel more than a year knows that the comments are actually quite useful – they allow us to put info data into a cell, without actually putting data in the cell. However, the standard way …

VBA – Make Excel Comments Beautiful Read more »

VBA – IIF() vs IF()

By Vitosh Posted on March 8, 2021 Posted in VBA \ Excel Tagged with condition, Excel, if, iif, VBA
VBA – IIF() vs IF()
Saw that cat, had to write a #VBA article to put it online!

What is the difference between IIF() and IF() in #VBA? The idea of IIF() is that it evaluates both the True and the False part of the condition, before evaluating the condition itself. Thus, if the False part throws an …

VBA – IIF() vs IF() Read more »

VBA – Hashing in Excel with HMACSHA1

By Vitosh Posted on March 1, 2021 Posted in VBA \ Excel Tagged with Excel, hashing, HMACSHA1, Sha1, VBA
VBA – Hashing in Excel with HMACSHA1

Hashing strings in general is useful. It is one of the good things, that we get from granted by the various .Net libraries and we should not try to do on our own, as the HMACSHA1 is quite a powerful …

VBA – Hashing in Excel with HMACSHA1 Read more »

Copyright © 2026 VitoshAcademy