返回列表 上一主題 發帖

Application.InputBox 可否設等待時間??

Application.InputBox 可否設等待時間??

Application.InputBox 可否設等待時間??
假如等待5秒沒輸入,自動以"n"輸入

好奇+1,這我之前也研究過,沒有找到答案,若沒有輸入會一直卡在那邊,後續的程式碼無法繼續運行
PKKO

TOP

Public Declare Function SetTimer Lib "user32" (ByVal hWnd As Long, _
    ByVal nIDEvent As Long, ByVal uElaspe As Long, ByVal lpTimerFunc As Long) As Long

Public Declare Function KillTimer Lib "user32" (ByVal hWnd As Long, ByVal nIDEvent As Long) As Long
Public PopTime As Long

Sub Test()
Dim x
PopTime = SetTimer(0, 0, 5000, AddressOf CloseInputBox)
x = Application.InputBox("請輸入")
If x = "" Then x = "n"
MsgBox x
KillTimer 0, PopTime
End Sub

Sub CloseInputBox(ByVal hWnd As Long, ByVal uMsg As Long, ByVal idevent As Long, ByVal Systime As Long)
Application.SendKeys "~", True
KillTimer 0, PopTime
End Sub

網路找到的,試試~~

TOP

Public Declare Function SetTimer Lib "user32" (ByVal hWnd As Long, _
    ByVal nIDEvent As Long, By ...
准提部林 發表於 2015-10-24 12:03


thanks!

TOP

回復 3# 准提部林


    准大好讚!'晚點測試一下~
PKKO

TOP

        靜思自在 : 【生命在呼吸間】佛陀說:「生命在呼吸間。」人無法管住自己的生命,更無法擋住死期,讓自己永住人間。既然生命去來這麼無常,我們更應該好好地愛惜它、利用它、充實它,讓這無常、寶貴的生命,散發它真善美的光輝,映照出生命真正的價值。
返回列表 上一主題