WorksheetFunction.Roman (Excel)

Converts an arabic numeral to roman, as text.

The following table describes the values that can be used for Arg2.

Roman (Arg1, Arg2)

Dim dblArg1 As Double: dblArg1 = 
Dim strRoman As String
strRoman = WorksheetFunction.Roman(Arg1:=dblArg1)


Arg1, Arg2

Arg1 (Double) - Number - the Arabic numeral that you want converted.

Arg2 - Form - a number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases