hi,
i would like to create a triange in a label that depend on a choosen number.
the traingle need to be from right to left.
i have a code that create a traingle but from up to down and i need to change it that it will be from right to left.

here is the code:

Private Sub Label1_Click()
Ans = InputBox("How many Base Rows in the Triangle ?")
Base = 2 * Ans - 1
While Base >= 1
STRG = STRG & Space(SP) + Application.Rept("*", Base) + Space(SP) + Chr(10)
Base = Base - 2: SP = SP + 1
Wend
Label1.Caption = STRG
End Sub

any ideas?
thanks