public Function Xingz(Shenr As Date) As String
Dim xJx As String
Dim Xz As String
xJx = Val(Str((Month(Shenr) + 10) & (Day(Shenr) + 10)))

Select Case xJx
Case 1130 To 1228
Xz = "水瓶座"
Case 1229 To 1330
Xz = "双鱼座"
Case 1331 To 1429
Xz = "白羊座"
Case 1430 To 1530
Xz = "金牛座"
Case 1531 To 1630
Xz = "双子座"
Case 1631 To 1731
Xz = "巨蟹座"
Case 1732 To 1832
Xz = "狮子座"
Case 1833 To 1932
Xz = "处女座"
Case 1933 To 2032
Xz = "天秤座"
Case 2033 To 2131
Xz = "天蝎座"
Case 2132 To 2231
Xz = "射手座"
Case 2232 To 2241
Xz = "摩羯座"
Case 1011 To 1129
Xz = "摩羯座"
End Select
Xingz = Xz
End Function

别见笑。