怎样用EXCEL制作彩( 二 )


    If txtMax.Value > spbMax.Max Then
        txtMax.Value = https://vvvtt.com/article/spbMax.Max
    ElseIf txtMax.Value < spbMax.Min Then
        txtMax.Value = https://vvvtt.com/article/spbMax.Min
    If
    '设置幸运号和解除号的规模
    设置号码规模
Sub
Private Sub txtMzhs_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtMzhs.Value > spbMzhs.Max Then
        txtMzhs.Value = https://vvvtt.com/article/spbMzhs.Max
    ElseIf txtMzhs.Value < spbMzhs.Min Then
        txtMzhs.Value = https://vvvtt.com/article/spbMzhs.Min
    If
Sub
Private Sub txtPch1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtPch1.Value > spbPch1.Max Then
        txtPch1.Value = https://vvvtt.com/article/spbPch1.Max
    ElseIf txtPch1.Value < spbPch1.Min Then
        txtPch1.Value = https://vvvtt.com/article/spbPch1.Min
    If
Sub
Private Sub txtPch2_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtPch2.Value > spbPch2.Max Then
        txtPch2.Value = https://vvvtt.com/article/spbPch2.Max
    ElseIf txtPch2.Value < spbPch2.Min Then
        txtPch2.Value = https://vvvtt.com/article/spbPch2.Min
    If
Sub
Private Sub txtPch3_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtPch3.Value > spbPch3.Max Then
        txtPch3.Value = https://vvvtt.com/article/spbPch3.Max
    ElseIf txtPch3.Value < spbPch3.Min Then
        txtPch3.Value = https://vvvtt.com/article/spbPch3.Min
    If
Sub
Private Sub txtScs_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtScs.Value > spbScs.Max Then
        txtScs.Value = https://vvvtt.com/article/spbScs.Max
    ElseIf txtScs.Value < spbScs.Min Then
        txtScs.Value = https://vvvtt.com/article/spbScs.Min
    If
Sub
Private Sub txtXyh1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtXyh1.Value > spbXyh1.Max Then
        txtXyh1.Value = https://vvvtt.com/article/spbXyh1.Max
    ElseIf txtXyh1.Value < spbXyh1.Min Then
        txtXyh1.Value = https://vvvtt.com/article/spbXyh1.Min
    If
Sub
Private Sub txtXyh2_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtXyh2.Value > spbXyh2.Max Then
        txtXyh2.Value = https://vvvtt.com/article/spbXyh2.Max
    ElseIf txtXyh2.Value < spbXyh1.Min Then
        txtXyh2.Value = https://vvvtt.com/article/spbXyh2.Min
    If
Sub
Private Sub txtXyh3_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    If txtXyh3.Value > spbXyh3.Max Then
        txtXyh3.Value = https://vvvtt.com/article/spbXyh3.Max
    ElseIf txtXyh3.Value < spbXyh3.Min Then
        txtXyh3.Value = https://vvvtt.com/article/spbXyh3.Min
    If
Sub
Sub 设置号码规模()
    '设置幸运号和解除号的规模
    spbXyh1.Max = txtMax.Value
    spbXyh2.Max = txtMax.Value
    spbXyh3.Max = txtMax.Value
    spbPch1.Max = txtMax.Value

推荐阅读