Hi all..

Is there a way to bypass the inputbox if the time has elapsed 30 seconds and nothing is entered in the Inputbox?

I'm using the following code.

[vba]Dim WeekNo As Integer
Dim WeekNo As Integer
Sub GetWeekno()
WkNo = 44
WeekNo = InputBox("Please Enter Week No. ", "Enter Week No. ", WkNo)
MsgBox WeekNo
End Sub
[/vba]

thnaks for all the help