May 2020 – Useful code

Month: May 2020

VBA – Convert Month Name to Number and Vice Versa

Posted on May 29, 2020 by

Convert number to name – [3 -> March] Converting month number to name in VBA is actually coming out of the box with the MonthName() function, which is built-in the stanard VBA library:

Sub MonthNameExample()
    
    Dim i As Long
    For i = 1 To 12
        Debug.Print MonthName(i)
        Debug.Print Format(MonthName(i, True))
    Next
    
End Sub

Sub MonthNameExample()

Dim i As Long

For i = 1 To 12

Debug.Print MonthName(i)

Debug.Print Format(MonthName(i, True))

End Sub

The result is not flabbergasting, but…

VBA Debugging – Video

Posted on May 22, 2020 by

Vitosh Posted in VBA \ Excel

I have decided to make a 19 minute YouTube video, to explain the basics of VBA debugging, as there are quite a few tricks that not everyone knows. The agenda: Properties Window -> F4 Immediate Window -> Ctrl + G…

VBA – Copying Excel worksheet to a new workbook without leaving the old Excel reference

Posted on May 4, 2020 by

Vitosh Posted in VBA \ Excel

Copying excel worksheets around is actually a piece of cake for a VBA developer (or so they/we think). Mainly because you can record the actions and then “learn” from them, editing a bit the code and etc. Well, there is…