Podes hacer algo asi y poner el select case adentro del for
Código [Seleccionar]
Option Explicit
Private Sub Form_Load()
Dim lVal As Long
Dim i As Long
lVal = 10
For i = Len(CStr(lVal)) - 1 To 0 Step -1
Debug.Print Mid$(CStr(lVal), Len(CStr(lVal)) - i, 1)
Next
End Sub