↓ 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

Home › 2021 › March
Python – Class Variable vs Instance Variables
Python

Python – Class Variable vs Instance Variables

Vitosh Mar 28, 2021 Tagged with Class Variable, Instance Variables, oop, Python

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__
Python

Python – Difference between __str__ and __repr__

Vitosh Mar 21, 2021 Tagged with dunder, Python, repr, str

__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
VBA \ Excel

VBA – Make Excel Comments Beautiful

Vitosh Mar 14, 2021 Tagged with edit comment, Excel, make comments float, unhide comments, VBA

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()
Saw that cat, had to write a #VBA article to put it online!
VBA \ Excel

VBA – IIF() vs IF()

Vitosh Mar 8, 2021 Tagged with condition, Excel, if, iif, VBA

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
VBA \ Excel

VBA – Hashing in Excel with HMACSHA1

Vitosh Mar 1, 2021 Tagged with Excel, hashing, HMACSHA1, Sha1, VBA

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