Converting Between Roman and Arabic Numerals in VBA Excel

The worksheet functions Roman() and Arabic() are used to convert between conventional Arabic numbers and Roman numerals. Note that the Arabic() function was introduced only in Excel 2013.

The following example converts the number 1984 to the Roman numeral text « MCMLXXXIV » and then converts it back:

Sub RomanArabic()
    MsgBox WorksheetFunction.Roman(1984)
    MsgBox WorksheetFunction.Arabic("MCMLXXXIV")
End Sub