- 帖子
- 5923
- 主題
- 13
- 精華
- 1
- 積分
- 5986
- 點名
- 0
- 作業系統
- win10
- 軟體版本
- Office 2010
- 閱讀權限
- 150
- 性別
- 男
- 來自
- 台灣基隆
- 註冊時間
- 2010-5-1
- 最後登錄
- 2022-1-23
        
|
23#
發表於 2013-4-2 17:28
| 只看該作者
回復 22# av8d
試試看 是這樣嗎?- Private Sub CommandButton1_Click()
- Dim CB As String, TB As String, ER As String, I As Integer
- CB = ComboBox1
- TB = TextBox1
- For I = 1 To 3
- If 確認密碼(CB, TB) = "密碼正確" Then
- GoTo MS
- Else
- TextBox1 = InputBox("密碼錯誤! " & I & "次", "警告!", "請輸入正確密碼!")
- TB = TextBox1
- End If
- Next
- MsgBox "密碼錯誤! 3次 關閉 Excel"
- Application.Quit
- Exit Sub
- MS:
- MsgBox "密碼正確"
- Username = ComboBox1
- Unload Me
- End Sub
- Private Function 確認密碼(CB As String, TB As String) As String
- Dim I As Integer
- 確認密碼 = "密碼錯誤"
- With Sheets("蓋棉被純聊天系統")
- For I = 3 To 5
- If CB = .Range("N" & I) And TB = .Range("O" & I) Then
- 確認密碼 = "密碼正確"
- Exit For
- End If
- Next
- End With
- End Function
複製代碼 |
|